create
database
link
mydblink
2
connect
to
test
identified
by
test123
3
using
'(description
=
4
(address_list
=
5
(address
=
(protocol
=
tcp)(host
=
192.168.1.210)(port
=
1521)))
6
(connect_data
=
(service_name
=
orcl)
7
)
8
)';
database
link
created.
sql>
select
count(1)
from
user_tables@mydblink;
count(1)
----------
6
註：
如果創建全局dblink，必須使用systm或sys用戶，在database前加public。