1、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 (责任编辑:IT) |