Oracle查询

oracle查询表在哪个用户下

表名必须大写

select owner from dba_tables where table_name='表名';

oracle 查询表属于哪个表空间

表名必须大写

select   tablespace_name,table_name  from user_tables where table_name='xxx';

 

Oracle中查看最近被修改过的表
select uat.table_name as 表名,(select last_ddl_time from user_objects where object_name = uat.table_name ) as 最后修改日期
from user_all_tables uat order by (select last_ddl_time from user_objects where object_name = uat.table_name ) desc

 

oracle查询单表占用空间的大小

SELECT segment_name AS TABLENAME,
BYTES B,
BYTES / 1024 KB,
BYTES / 1024 / 1024 MB
FROM user_segments
where segment_name = upper('tablename');