Bad Partition

[lesstjm]

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.

[mike9]

hi,

just wondering: how did you create a new partiton for a existing partitioned table under a wrong owner?

[rad_jen]

Login as sys or system and drop the partition.

[sreddy]

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 ?

[cruser3]

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 ?


Regards,

[davey23uk]

example?

[cruser3]

OK - was confused by seeing the DBA_TAB_PARTITIONS view and this thread - the same create table script was run under the 2 schema owners for some reason ! So that solves this !!