9i oracle数据库迁移到11G(exp) (8)

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';

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/zyfsjf.html