Home > Database > Oracle > How to delete dblink in oracle

How to delete dblink in oracle

WBOY
Release: 2022-06-13 10:19:25
Original
9737 people have browsed it

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.

How to delete dblink in oracle

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名称;
Copy after login

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;
Copy after login

Delete the private database link named polarlink:

DROP DATABASE LINK polarlink;
Copy after login

2, Delete dblink with private permission

drop database link dblink名称;
Copy after login

Extension:

View dblink

(1)View all users

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

How to delete dblink in oracle

(2) View all users

SELECT * FROM DBA_DB_LINKS;
Copy after login

How to delete dblink in oracle

--View this user

SELECT * FROM USER_DB_LINKS;
Copy after login

How to delete dblink in oracle

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template