全部博文
-
编辑 删除
Oracle10g Database Table Partition Testcase-4 严于律己
SELECT INDEX_NAME,PARTITION_NAME,STATUS FROM DBA_IND_PARTITIONS WHERE INDEX_OWNER='IPS2' ORDERBY INDEX_NAME,PARTITION_NAME --ADD PARTITION ALTER TABLE IPS2.TIPS_TRD_HK_P ADD PARTITION TRD_HK_2015 VALUES LESS THAN(to_date('20160101','yyyymmdd')); SELECT INDEX_NAME,TABLE_NAME,STATUS,PARTITIONED FROM DBA_INDEXES WHERE OWNER='IPS2' ANDTABLE_NAME='TIPS_TRD_HK_P'
