"Copy Table" in "Command Window" possible?

[kirilb]

In sqlplus there is command to copy table from one db to other. I am wondering how enable this in the Command Window. I am trying with following:

connect username/pw@DB1

COPY FROM username/pw@DB2 -
REPLACE My_Table    -
USING -
SELECT * FROM Other_Table;

but get the error message "ORA-00900: invalid SQL statement". What is my error?

 

[Marco Kalter]

The COPY command is a SQL*Plus command that is not supported by the Command Window.