In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.