Oracle DBA, How To, Error, Cause and Action

ORA-02080: database link is in use

ORA-02080: database link is in use




Cause: a transaction is active or a cursor is open on the database link given in the alter session close database link command.




Action: commit or rollback, and close all cursors