Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deleting single partition from table

user11076992Dec 4 2009 — edited Dec 8 2009

Hi,

I have a table with 4 partitions and I want to delete all the partitions. However when I tried deleting, I could delete only three partitions and I am unable to delete the last parition for that particular table. Since this table has many dependencies I do not want to risk droping the table and recreate it. Is there any way I can drop all the partitions from a table keeping all the dependencies..???

I would be obliged if anyone could help.

Edited by: user11076992 on Dec 4, 2009 12:04 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2010

Added on Dec 4 2009

#dba, #general-database-discussions

8 comments

2,898 views