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