Database Environment: Client: WinXP ORACLE9.2.0.1 Client Server A: Win2003 Oracle9.2.0.5 Server B: HP Unix 11i Oracle9.2.0.5
Init Configuration Client: Connection Server A-SID_NAME: PGJT Server A: Connection Server B-SID_NAME: PGJT1
On service A: SQL> conn / as sysdbasql> Copy from manager / system @ pgjt1 create test_copy1 using select * from V $ log; an array read / binding size is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80) Table Test_copy1 has been created.
6 lines are selected from Manager @ pgjt1. The 6 lines are inserted with Test_copy1.6, which is already submitted to Test_copy1 (located in the default host).
On the client: SQL> conn sys / sys @ pgjt as sysdba; sql> copy from manager / system @ pgjt1 create test_copy14 using select * from v $ log; array read / binding size is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length is 80)
Error: ORA-01727: Numeric Precision Specifier Is Out of Range (1 to 38)
----------------------------------- # actually an error, don't know why # ------- ---------------------------- 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 DATESQL> copy from manager / system @ PGJT1 CREATE TEST_COPY13 Using SELECT First_TIME F ROM 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) Table Test_copy13 has been created.
6 lines are selected from Manager @ pgjt1. The 6 lines are inserted with Test_Copy13.6 The lines have been submitted to Test_Copy13 (located in the Default Host connection).
SQL> COPY from Manager / System @ pgjt1 create test_copy14 Using SELECT STATUS FROMV $ LOG; A array read / binding size is 15. (Array size is 15) will be submitted when completed. (Submitted to 0) The maximum is 80. (Length 80) Table Test_copy14 has been created.
6 lines are selected from Manager @ pgjt1. The 6 lines are inserted with Test_Copy14.6, and the Test_Copy14 is submitted to Test_Copy14 (located in the Default Host connection).
SQL> COPY from manager / system @ pgjt1 create test_copy15 using select group # fromv $ 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: Numeric Precision Specifier Is Out of Range (1 to 38)
----------------------------------- # Note that only when the number is inserted, will it be Client Version Question # -----------------------------------
