1、查看表空间中的表
select table_name,instances,tablespace_name from user_tables where tablespace_name='DIET';
2、查看表的字段名称、属性、大小
DESC tableName
3、查看序列Sequence
select * from user_sequences;
select * from dba_sequences t where t.sequence_name='sequence名称大写';