Friday, August 15, 2008

Split a Partition

# split a partitions
ALTER TABLE "BI_MIFID_STAGING"."SBPRICE" SPLIT PARTITION "SBPRICE_DE010908" AT (TIMESTAMP'2008-08-01 00:00:00')
INTO (PARTITION "SBPRICE_DE010808", PARTITION "SBPRICE_DE010908");

# check for unusable indexes

select count(*) from dba_indexes where status = 'UNUSABLE';
select count(*) from dba_ind_partitions where status = 'UNUSABLE';
select count(*) from dba_ind_subpartitions where status = 'UNUSABLE';