Database - RAC/Scalability (MOSC)

MOSC Banner

ora-00054 resource busy and acquire with nowait specified While truncating table

edited Apr 21, 2016 5:03AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center