select segment_name, segment_type, bytes
from dba_segments
where owner = 'SYS'4 and segment_name in (select index_name
from dba_indexes
where table_owner = 'SYS'7 and table_name = 'T'8 union
select 'T' from dual);
SYS@HUIYI>create table t
2 (3 col01 date
4 )5 /表已创建。
SYS@HUIYI>insert into t values(sysdate);已创建 1 行。
SYS@HUIYI>commit;提交完成。
SYS@HUIYI>create index t_idx on t(col01);索引已创建。
SYS@HUIYI>select segment_name, segment_type, bytes
2 from dba_segments
3 where owner = 'SYS'4 and segment_name in (select index_name
5 from dba_indexes
6 where table_owner = 'SYS'7 and table_name = 'T'8 union
9 select 'T' from dual);SEGMENT_NAME SEGMENT_TYPE BYTES--------------------------------------------------------------------------------- ------------------ ----------T TABLE 65536
T_IDX INDEX 65536------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/594892/viewspace-924212/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/594892/viewspace-924212/