DBA Hub

📋Steps in this guide1/1

Create/drop database link

-- Create public database link

oracle configurationintermediate
by OracleDba
12 views
1

Create/drop database link

-- Create public database link -- Create private database link under Scott -- Drop public database link -- Drop private database link

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Create public database link LINK_PUB connect to system identified by oracle using 'PRODB';
where
PRODB
- >
tnsname
of the target
db
added in
tnsnames
.ora
connect scott/tiger
create database link LINK_PRIV connect to system identified by oracle using 'PRODB';
drop public database link TEST_LINK ;
connect scott/tiger
drop database link LINK_PRIV;
NOTE - Private database link can be dropped only by the owner of the database link

Comments (0)

Please to add comments

No comments yet. Be the first to comment!