第119-120次：2015-03-30星期一， 2015-04-01星期三

botang

1. select  i.INDEX_NAME ,i.STATUS from dba_indexes i where i.TABLE_NAME  like 'T%00' and i.OWNER='SH';
   
2. 
   
3. select  * from dba_part_indexes i where i.TABLE_NAME='ORDERS' and i.OWNER='SH';
   
4. 
   
5. SELECT ui.index_name, DECODE(uip.status,null,ui.status,uip.status)
   
6. FROM dba_ind_partitions uip, dba_indexes ui
   
7. WHERE ui.index_name=uip.index_name(+)
   
8. AND ui.table_name='ORDERS' and ui.OWNER='SH'
   
9. GROUP BY ui.index_name, DECODE(uip.status,null,ui.status,uip.status);
   
10. 
    
11. 
    
12. select t.PARTITIONING_TYPE, t.TABLE_NAME, t.REF_PTN_CONSTRAINT_NAME ,t.INTERVAL
    
13. from dba_part_tables t where t.TABLE_NAME in ('T100','T200','T300')  and t.OWNER='SH';
    
14. 
    
15. 
    
16. select tp.TABLE_NAME,     tp.PARTITION_NAME, tp.HIGH_VALUE ,tp.TABLESPACE_NAME
    
17.    from dba_tab_partitions tp where tp.TABLE_NAME in ('T100','T200','T300')  and  tp.TABLE_OWNER='SH'
    
18.    order by tp.table_NAME , tp.PARTITION_NAME;
    
19.    

复制代码