drop database link DB_LIN_10.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_10.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'DB_110_STD';
drop database link DB_LIN_100.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_100.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'zk_lin_100';
drop database link DB_LIN_115.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_115.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'ZK_115';
drop database link DB_LIN_120.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_120.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'ZK_120';
drop database link DB_LIN_61.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_61.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'ZK_61';
drop database link DB_LIN_75.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_75.SJZK.COM.CN
connect to SMART identified by lzxMZD135468
using 'ZK_75';
drop database link DB_LIN_DB166.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_DB166.SJZK.COM.CN
connect to SMART identified by lzxMZD135468
using 'DB166';
-- Drop existing database link
drop database link DB_LIN_DW02.SJZK.COM.CN;
-- Create database link
create database link DB_LIN_DW02.SJZK.COM.CN
connect to SMART identified by lzxMZD135468
using 'DW02';
-- Drop existing database link
drop database link DB_WIN_99.SJZK.COM.CN;
-- Create database link
create database link DB_WIN_99.SJZK.COM.CN
connect to SMART identified by LZXMZD135468
using 'zk_win_99';
9i oracle数据库迁移到11G(exp) (8)
内容版权声明:除非注明,否则皆为本站原创文章。