We have a partitioned table. I added a data partition to the table under the wrong owner. the problem is that when I created the data parition it also created a index partition under the table owner. So when I go to drop the data parition it says that I can't because the index partition is owned by someone else. How do I solve this problem? I checked Metalink but did not find anything.
Originally posted by rad_jen Login as sys or system and drop the partition.
Do this as last resort , after Backing up table. Who owns the table ? It doesn't make sense to me table/partition owner and table/partition index owner is different.
how did you create this partition with index under different ownership ?
Was searching this thread for a problem I face and picking up on this thread - we've got a production env. with a partitioned table which shows 2 owners for a range partitioned table in the DBA_TAB_PARTITIONS view - one is the schema owner and the other a user created with DBA privileges.
Can any1 throw some light on how this can happen ?
Last edited by cruser3; 05-16-2006 at 05:22 PM.
Reason: change data