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

No comments:

Post a Comment

Thanks for your comment.