Re: Copy data from one database instance to another on the same server

From: CJM <cjmnews04_at_REMOVEMEyahoo.co.uk>
Date: Thu, 2 Nov 2006 11:53:26 -0000
Message-ID: <4qu4hmFon9qdU1@individual.net>

"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:

RemoteOperationException: ERROR: Wrong password for user

I've looked around for a solution to this but all the examples found point towards a permissions issue on Windows. unfortunately our server runs Linux! Anybody experienced this problem on a Linux box?

Any alternative methods of copying the data?

Thanks

Chris Received on Thu Nov 02 2006 - 05:53:26 CST