Bad Partition

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.

hi,

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

Login as sys or system and drop the partition.

Quote:

---

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 ?


Regards,

:)

example?

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 !!

:)