Re: Copy a table from 1 schema to another

rj wrote:
> I get the message:
> DDL Operations are not allowed on a remota database

Correct. However I don't think you ever specified the target user was in a remote database.
You now either need to split it in two
- create table at the remote site
- insert into <target user>.<table_name>   select * from <source user>@<old_database>.<table_name>

or look up the Sql*plus COPY command (which will be deprecated) in the Sql*plus reference manual.

I will bail out of this thread as I feel you are playing games with me, consistently refusing to provide sufficient detail. After all the answer to your question *can* be resolved by looking in the documentation.
(and you seem to misuse this forum as a replacement for reading the documentation)

-- 
Sybrand Bakker
Senior Oracle DBA