Oracle基本操作笔试面试题之dblink操作

dblink创建

create [public] database link dblink_name connect to username identified by

password using ‘connectstring’

例如：create public database link db_file_name1 connect to oracle identified by oracle_123 using CC

2、dblink操作

select * from dba_objects_name1@db_file_name1

update table table_name@db_file_name1 set 字段=、、、

3、dblink删除

drop [public] database link dblink_name