Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Copy data from one database instance to another on the same server

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:16:14 -0000
Message-ID: <4qu2buFoeuvbU1@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 Received on Thu Nov 02 2006 - 05:16:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US