第55次：2016-03-17星期四

botang · 发表于 2016-3-18 17:11:58

游客，本帖隐藏的内容需要积分高于 100 才可浏览，您当前积分为 0

select * from dba_tables t where t.owner='HR'
and t.table_name='T05318_MIGRATE';
select * from dba_Tablespaces;
create tablespace tbs16k datafile size 10M autoextend on blocksize 16384;
select * from dba_segments s where s.owner='HR' and s.segment_name='T05318_NO_D';
select * from dba_tables s where s.owner='HR' and s.table_name='T05318_NO_D';
select * from dba_extents s where s.owner='HR' and s.segment_name='T05318_NO_D';
select * from dba_segments s where s.owner='HR' and s.segment_name='PART1';
select * from dba_segments s where s.owner='HR' and s.segment_name='IPART2';
---
select * from dba_segments s where s.owner='HR' and s.segment_name='IOT1_PK';
select * from dba_indexes i where i.owner='HR' and i.index_name='IOT1_PK';
select * from dba_objects o where o.owner='HR' and o.object_name='IOT1';
select * from dba_tables t where t.owner='HR' and t.table_name like '%81542';
select * from hr.SYS_IOT_MAP_81542;
---
select status from dba_indexes i where i.owner='HR'
and i.index_name='I05318_UNUSABLE';
select status
from dba_ind_partitions i where i.index_owner='HR' and i.index_name='IPART1';
select s.segment_name , s.bytes/1024/1024
from dba_segments s where
s.owner='HR' and s.segment_name
like '%05318_COMPRESS';
select i.compression from dba_indexes i where i.owner='HR'
and i.index_name='I05318_COMPRESS';

复制代码