Re: Copy a table from 1 schema to another

rj wrote:
> Thanks for the reply, but i get the followong error:
>
> ORA-02019: connection description for remote database not found.

>From the error manual

ORA-02019 connection description for remote database not found

Cause: An attempt was made to connect or log in to a remote database using a connection description that could not be found.

Action: Specify an existing database link. Query the data dictionary to see all existing database links. See your operating system-specific Net8 documentation for valid connection descriptors.

So without further info at what you were actually doing, no one can answer.
Please look up error messages yourself in the future.

-- 
Sybrand Bakker
Senior Oracle DBA