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

Good point about the temporary tables. To make things easy, make sure your environment has this set
export ORACLE_HOME=<path to oracle home> export PATH=$ORACLE_HOME/bin;./$PATH
export ORACLE_SID=<Sid of DB you are exporting>

Also, if you cannot do it, ask you nearest DBA : )

Frank van Bortel wrote:
> CJM schreef:
> > 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
> >
> >
>
> If they are really temporary tables, the methods
> described won't work. You can:
> - use an insert into remote table from temporary
> table during the session
> - use an insert into local table from temporary
> table, and use one of the methods described
> by others.
>
> The fact you use temporary tables and want to
> copy them, makes me fear your mistake oracle for
> an other product, and you are not using temporary
> tables at all.
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Thu Nov 02 2006 - 19:04:44 CST