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