DROP DATABASE LINK

Description

Deletes database link objects.

Syntax

DROP [ PUBLIC ] DATABASE LINK [ IF EXISTS ] dblink_name;

Parameters

dblink_name
Name of a connection object.
IF EXISTS
Reports a notice instead of an error if the specified DATABASE LINK does not exist.
PUBLIC
Specifies the connection type. If PUBLIC is not specified, the database link is private by default.

Examples

-- Create an ORA-compatible database.
gaussdb=# CREATE DATABASE ora_test_db DBCOMPATIBILITY 'ORA';

-- Switch to another database.
gaussdb=# \c ora_test_db

-- Create a user with the system administrator permission.
ora_test_db=# CREATE USER user1 WITH SYSADMIN PASSWORD '********';
ora_test_db=# SET ROLE user1 PASSWORD '********';

-- Create a private database link.
ora_test_db=# CREATE DATABASE LINK private_dblink CONNECT TO 'user1' IDENTIFIED BY '********' USING (host '192.168.11.11',port '54399',dbname 'db01');

-- Delete the private database link.
ora_test_db=# DROP DATABASE LINK private_dblink;

-- Create a public database link.
ora_test_db=# CREATE PUBLIC DATABASE LINK public_dblink CONNECT TO 'user1' IDENTIFIED BY '********' USING (host '192.168.11.11',port '54399',dbname 'db01');

-- Delete the public database link.
ora_test_db=# DROP PUBLIC DATABASE LINK public_dblink;

-- Delete the created user.
ora_test_db=# RESET ROLE;
ora_test_db=# DROP USER user1;

-- Switch back to the initial database and delete the test database. Replace postgres with the actual database name.
ora_test_db=# \c postgres
gaussdb=# DROP DATABASE ora_test_db;