hey,
I have a big loading process into a certain fact table. the table is partitioned first by interval on a date column and then sub partitioned by hash. this is a big fact table so there are alot of bitmap indexes on it.
i want to disable all indexes on a specific partition given a certain value of the partition key.
is there any nice good looking way of finding the partition name by value ?
i would realy like to avoid running a loop on the high_value long column in all_tab_partitions
the etl process is running on the entire partition - after finding the partition name i would disable all sub partitions
if i could only do something like...
select $partition_name from some_table for (to_date('01/03/2012','dd/mm/yyyy'));
i'm using oracle 11.2.0.2