Database Environment: Client: WinXP Oracle9.2.0.1 Client 32bit Server A: Win2003 Oracle9.2.0.5 32Bit Server B: WinXP Oracle9.2.0.1 32bit Server C: HP-UX 11i Oracle9.2.0.5 64bit
Init Configuration Client: Connection Server A-SID_NAME: PGJT Server A: Connection Server B-SID_NAME: Oemrep Connection Server C-SID_NAME: PGJT1
SQL> Conn Sys / Sys @ pgjt as sysdba is connected. SQL> CREATE DATABASE LINK DB_LINK_WWDB Connect To Scott Identified by Tiger Using 'Oemrep'
The database link has been created. SQL> SELECT * from dept @ db_link_wwdb;
DEPTNO DNAME LOC ---------------------- ------------- 10 Accounting 12 20 Research 13 30 Sales 13 40 Operations 13 10 Accounting 20 Research 30 Sales 40 Operations
8 lines have been selected.
SQL> COPY from Scott / Tiger @ Oemrep Create Test_CP Using SELECT * from de PEPT;
The size of the array read / binding is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80) Table Test_cp has been created.
8 lines are selected from Scott @ Oemrep. 8 lines are inserted into Test_CP. The 8 lines have been submitted to Test_CP (located in the Default Host connection).
SQL> SELECT * from Test_cp;
DEPTNO DNAME LOC ---------------------- ------------- 10 Accounting 12 20 Research 13 30 Sales 13 40 Operations 13 10 Accounting 20 Research 30 Sales 40 Operations
8 lines have been selected.
SQL> Copy to Manager / System @ Pgjt1 Create Test_cp using select * from test_cp;
The size of the array read / binding is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80) Table Test_cp has been created.
The selected 8 lines come from the Default Host connection. 8 lines are inserted into Test_CP. 8 lines have been submitted to Test_CP (located in Manager @ PGJT1).
SQL> COPY from Manager / System @ pgjt1 create test_cp1 using select * from test_cp;
The size of the array read / binding is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80) Table Test_cp1 has been created. 8 lines in Manager @ pgjt1. 8 lines are inserted with Test_CP1.8, which is already submitted to Test_CP1 (located in the default host).
SQL> COPY from Manager / System @ pgjt1 create test_cp2 Using SELECT * FROM V $ log;
The size of the array read / binding is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80)
Error: ORA-01727: Digital Accuracy Settings Benefits (1 to 38) SQL> Conn Manager / System @ PGJT1 is connected. SQL> DESC V $ log; is the name is empty? Type ------------------------------------- ------------------------------------------------ ------ Group # Number thread # Number Sequence # Number Bytes Number Members Number Archived Varchar2 (3) STATUS VARCHAR2 (16) FIRST_CHANGE # Number First_time Date
SQL> DESC TEST_CP1; Error: ORA-04043: Object Test_CP1 does not exist
SQL> DESC TEST_CP; is the name is empty? Type --------------------------------------- ------------------------------------------------ ---- Deptno Number (2) DName Char (14) LOC Char (13)
Some netizens think that V $ log is a synonym (view) that cannot be copy. Test SQL> COPY from System / System @ Oemrep Create Test_cp5 Using SELECT * FROM V $ log; the array read / combined size is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80) Table Test_cp5 has been created.
3 lines are selected from System @ Oemrep. 3 rows are inserted with Test_CP5.3 rows to Test_CP5 (located in the default host).
SQL> Copy to Manager / System @ pgjt1 create test_cp5 using select * from v $ log;
The size of the array read / binding is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80)
Error: ORA-01727: Digital Accuracy Signal Benefits (1 to 38)
in conclusion:
Oracle9i 64bit and 32bit copies will have problems, mainly due to the fact that the system's self-construction table is different.
