Oracle PL/SQL: Database Links: Close Database Link - If you want to close a link, issue the following statement, where refers to the name of the link.<b

Quick Search:

Oracle PL/SQL: Database Links: Close Database Link

Jump to:

Category: >> Oracle PL/SQL >> Database Links: Close Database Link

<< last

next >>

Snippet Name: Database Links: Close Database Link

Description: If you want to close a link, issue the following statement, where refers to the name of the link.

Note that this statement only closes the links that are active in your current session.

Also see:
» Create Database Link
» Database Link
» Create DB Link

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

ALTER SESSION CLOSE DATABASE LINK <link_name>;
 
-- drop a public link:
DROP PUBLIC DATABASE LINK <link_name>;