第21/22/23/24单：2015-10-17和2015-10-18双休

botang

1. select  i.index_name , ip.partition_name , decode(ip.status  , null,i.status, ip.status)  
   
2.   from dba_indexes i , dba_ind_partitions   ip
   
3.   where i.index_name=ip.index_name(+)      and i.table_name='ORDERS'   and i.owner='SH';
   
4.   
   
5.   
   
6.   
   
7. select  * from dba_part_indexes i where  i.table_name ='ORDERS'  and i.owner='SH';

复制代码

1. select  *  from dba_segments s where s.owner='SH' and s.segment_name in ('ORDERS','ORDER_ITEMS');
   
2. 
   
3. 
   
4. select  *  from
   
5. dba_tab_partitions t where t.table_name  in ('ORDERs','ORDER_ITEMS') and  t.table_owner='SH'
   
6. 
   
7. order by  t.partition_position,t.table_name;

复制代码