Skip to Main Content

SQL & PL/SQL

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!

Truncating subpartition

Arunadeepti JakkaJun 4 2020 — edited Jun 5 2020

Hi all ,

I have a table that has around 3 partitions [ A,B,C]  and in each partition I have 2 sub partitions.

I am inserting data into a sub partition  named ABC  , also at the same time  I am  truncating another sub partition DEF with below command. Both ABC and DEF are inside partition named A

ALTER TABLE  TABLENAME TRUNCATE SUBPARTITION DEF DROP STORAGE.

Is this valid ?

I am getting ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

Is this because that I cant do both at the same time . Please let me know.

Thanks

This post has been answered by Solomon Yakobson on Jun 4 2020
Jump to Answer
Comments
Post Details
Added on Jun 4 2020
4 comments
3,297 views