Shulou(Shulou.com)06/01 Report--

Create a public dblink.

Create public database link test_link connect to csservicedb identified by huawei123using'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.119) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)'; Database link created.

SQL > desc cs_user;ERROR:ORA-04043: object cs_user does not existSQL > desc cs_user@test_link; Name Null? Type-PK_BUR_USERID NOT NULL VARCHAR2 (18) BUR_USER_FLAG NOT NULL VARCHAR2 (32) select * from dba_objects where object_type='DATABASE LINK' Select owner, db_link from dba_db_links;-check dblink's owner and link names

Delete the dblink.

SQL > DROP PUBLIC DATABASE LINK csmain;Database link dropped.SQL > DROP PUBLIC DATABASE LINK csserver;Database link dropped.SQL >

If public is not added to the statement, the owner created is the currently connected user.

SQL > create database link CSMAIN connect to csmaindb identified by huawei123using'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.119) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = orcl)'; SQL > select owner, db_link from dba_db_links OWNER DB_LINK---CS_AUX CSMAINCS_AUX CSSERVER

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.