ora-00054 resource busy and acquire with nowait specified While truncating table
HI All,
We are purging all rows from table through a maintenance job in Oracle 11.2.0.3 db.
We are using truncate table <table_name> command here.
But when we are are testing it , we are facing following error.
ora-00054 resource busy and acquire with nowait specified
I searched in google and found many options for that like using DDL_LOCK_TIMEOUT parameter and putting table in read only mode to prevent DML operation during truncate job.
My question is,can we truncate table while it is in read only mode?
Thanks,
Chinna.