Oracle查询表创建时间，更新时间，用户信息，表类型，查询表结构等

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME ='your_table_name'  查询表所有的储存信息SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME ='y