Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy data from one database instance to another on the same server
"CJM" <cjmnews04_at_REMOVEMEyahoo.co.uk> wrote in message
news:4qu2buFoeuvbU1_at_individual.net...
>I have some data in a couple of temporary tables in a schema in the live
>database. I want to copy the data to the same schema on a test database
>that is on the same server.
>
> What is the best method of doing this? Can I use SQL Developer/PL/SQL, or
> must I use an external tool?
>
> Thanks
>
> CJM
>
I've tried using the Import From Database feature in OEM, but when I enter the Host Credentials I get the following error: Received on Thu Nov 02 2006 - 05:49:36 CST