--回收表
select * from user_recyclebin;
--查询表分区
select distinct table_name from user_tab_partitions;
--查询表
select * from user_tables;
--查询表字段
select * from user_tab_columns;
--查询表comment
select * from user_tab_comments;
--查询表空间
select * from v$datafile;
--查询目录
select * from alL_directories;
--查询所有的 object
select * from all_objects;
--查询procedure\function等语句
select * from all_source;
--查询
select * from all_constraints;
其中 all_constraints.CONSTRAINT_TYPE 为:
C Check on a table
O Read Only on a
P Primary Key
R Referential AKA Foreign Key
U Unique Key
V Check Option on a view
等等。用到再记录。