TOracleScript... does not what I want

[Fabian]

Hello

I want to use the TOracleScript Component for this script:
COPY FROM MYSCHEMA/HELLO@TESTDB
TO MYNEWSCHEMA/HELLO@TESTDB
REPLACE MYTABLE USING SELECT * FROM MYTABLE;

In the SQL*Plus Worsheet the Script works fine, the table is copied in the new schema.
But the TOracleScript Component returns "OK" after execution, but the Table is not copied.

What am I doing wrong?

Thanks for your help.

Regards Fabian

 

[Marco Kalter]

The copy command is an SQL*Plus command. Only the SQL commands listed in the SQL Reference Guide, PL/SQL Blocks, and the documented non-SQL commands are supported.