How to delete dblink in oracle

How to delete dblink in oracle: 1. Use the "drop public database link dblink name;" statement to delete the dblink with public permissions; 2. Use the "drop database link dblink name;" statement to delete the private permission dblink.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

How to delete dblink in oracle

1. Delete the dblink with public permission

drop public database link dblink名称;

DROP DATABASE LINK Delete the existing database link. To execute this command, you must be the owner of the database link.

Example

Delete the public database link named oralink:

DROP PUBLIC DATABASE LINK oralink;

Delete the private database link named polarlink:

DROP DATABASE LINK polarlink;

2, Delete dblink with private permission

drop database link dblink名称;

Extension:

View dblink

(1)View all users

SELECT OWNER,OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='DATABASE LINK';

(2) View all users

SELECT * FROM DBA_DB_LINKS;

--View this user

SELECT * FROM USER_DB_LINKS;

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to delete dblink in oracle. For more information, please follow other related articles on the PHP Chinese website!