Re: Copy

[Yechiel Adar]

I checked the docs for 8.1.6 and 9.0.1. I think that the copy command is new in 9i. make sure that you are logged on to 9i sqlplus when you issue this command.   Yechiel Adar Mehish ----- Original Message ----- From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Friday, July 05, 2002 10:08 PM Subject: Copy Hi list,   I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB 8.1.7 on NT using this statement   COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT * FROM DATOS_BALANCES;   ERROR at line 1: ORA-00900: invalid SQL statement   Do I need a DBLINK, if yes, is it obligatory ?   TIA,     Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121