| sqlplus [message #69597] |
Wed, 06 February 2002 03:27  |
youcef
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
I have a probleme when i use copy command
COPY FROM username/password@db_source TO username/password@db_destination
*
ERROR at line 1:
ORA-00900: invalid SQL statement
the username , password and the sql command are corrects.
|
|
|
|
| Re: sqlplus [message #69610 is a reply to message #69597] |
Thu, 07 February 2002 00:30  |
R.SIVAKUMAR
Messages: 48
Registered: February 2002
|
Member |
|
|
COPY FROM SCOTT/TIGER@A1 TO SCOTT/TIGER@A2
CREATE EMP
USING SELECT * FROM EMP;
-------------------------------------
you can use APPEND, CREATE, INSERT or REPLACE commands.
BYE
SIVA
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
