oracle对象创建时间查看

1、查看oracle中的表等对象创建时间

SELECT created FROM all_objects WHERE owner = '表的所有者' AND object_name = '表的名称' AND object_type = 'TABLE';

2、查看表空间创建时间即表的数据文件添加时间

select * from v$datafile order by creation_time desc