Database Administration (MOSC)

MOSC Banner

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

edited May 20, 2019 3:57AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi all

I would ask you if you have experiences with ora-00054 connected with alter table truncate partition drop storage .

Our developer use ETL witch creates a lot of independent jobs and part of it is alter table truncate partition drop storage .

But each job truncates different partition in the some table .  This partition table doesn't have index , constraints (only  check not null )

can you explain me where could be problem ?

Thank Tou Brano

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