database link
are alter database link
create database link
drop database link
create database link tq84_remote_db connect to usr_abc identified by secretGarden using 'srv:1521/ora19';
drop database link tq84_remote_db; -- ORA-02018: database link of same name has an open connection alter session close database link tq84_remote_db; -- ORA-02080: database link is in use begin dbms_session.close_database_link('tq84_remote_db'); end; / -- ORA-02080: database link is in use select logged_on, open_cursors, in_transaction from v$dblink where db_link like 'TQ84_REMOTE_DB'; commit; alter session close database link tq84_remote_db; -- Session altered drop database link tq84_remote_db; -- Database link TQ84_REMOTE_DB dropped.