-
ORA-00054 - Resource busy and requires nowait
When I run an analyze on one of our schemas , code below:
BEGIN DBMS_STATS.gather_schema_stats (ownname => 'ISSLIVE', cascade =>true,estimate_percent => dbms_stats.auto_sample_size); END;
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
This job is scheduled to run at 1am and does not coincide with another job. Any reason why I keep getting this? The same code runs without errors in other databases.
Any suggestions please.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|