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

I looked at using EXP/IMP but the environment wasn't set up correctly (ORACLE_HOME not set etc) so while my colleagues was looking into that I looked at using SQL*Plus. Initially, I was going to use the DB Link/'Create Table As...' method, but then I came across this method:

copy from uid/pwd_at_DB to uid/pwd_at_DB2 replace TABLENAME using Select * from TABLENAME; ...and it worked a treat.

Thanks to all those who helped.

Chris Received on Fri Nov 03 2006 - 04:37:15 CST