-
ORA-00060: deadlock detected while waiting for resource
I am trying to create a snapshot / materialized view from once instance to another and getting this error message.
Any ideas what the issue is??? It seems to erroring out at this point:
SELECT * FROM 'XXXX'.CUSTOMER@XXX.world
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 174
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 420
ORA-06512: at line 1
-
Please look at the alert.log and search for ora-0060 there you'll find a reference to a trace file, generated by this error and describing who waits for what and holds what, leading to the dead lock. Then search Metalink for Ora-0060 and I belive you'll find a note describing how to interpret the trace file
Regards
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
|
Click Here to Expand Forum to Full Width
|