$ export ORACLE_SID=TEST
Administrator@D6-WG ~
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on 星期四 7月 5 10:47:31 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:47:31 SQL> create public database link nronline222 connect to test identified by test using 'nronline222';
create public database link nronline connect to test identified by test using 'nronline';
数据库链接已创建。
已用时间: 00: 00: 00.06
10:47:40 SQL>
数据库链接已创建。
已用时间: 00: 00: 00.01
10:47:43 SQL>
Administrator@D6-WG ~
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on 星期四 7月 5 10:47:31 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
10:47:31 SQL> create public database link nronline222 connect to test identified by test using 'nronline222';
create public database link nronline connect to test identified by test using 'nronline';
数据库链接已创建。
已用时间: 00: 00: 00.06
10:47:40 SQL>
数据库链接已创建。
已用时间: 00: 00: 00.01
10:47:43 SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25680865/viewspace-734618/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25680865/viewspace-734618/