日期:2014-05-17 浏览次数:21040 次
OS:Ubuntu Server 8.04.1 IP:192.168.0.2 Computer Name:Prod Oracle SSID:XE SYS Password: dbpw
OS:win2k3 IP:192.168.0.3 Computer Name:Test Oracle SSID:XE SYS Password: dbpw
从B电脑上的Oracle Xe复制某些表的记录到A电脑的Oracle XE中.
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Prod)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) TXE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) )
root@Prod:/home/user# sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 11 14:18:09 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn sys@XE as sysdba Enter password: Connected. SQL> copy from sys/dbpw@TXE to sys/dbpw@XE replace AD_MENU_TRL using select * from AD_MENU_TRL; Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80) ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER SQL>
root@Prod:/home/user# export TWO_TASK=XE root@Prod:/home/user# sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 11 14:18:09 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn sys as sysdba Enter password: Connected. SQL> copy from sys/dbpw@TXE to sys/dbpw@XE replace AD_MENU_TRL using select * from AD_MENU_TRL; Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80) ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER SQL>