Home » SQL & PL/SQL » SQL & PL/SQL » database copying (Oracle 9i)
database copying [message #323865] Thu, 29 May 2008 21:26 Go to next message
Messages: 7
Registered: December 2007
Location: INDIA
Junior Member

Let we consider two separate databases with username Scott.

Both users have a table called Empmaster which one contain data

where another doesnot. Suppose need to copy data from one user

to another what are the methods.

With regards
Re: database copying [message #323866 is a reply to message #323865] Thu, 29 May 2008 21:44 Go to previous messageGo to next message
Messages: 2794
Registered: April 2006
Senior Member
Create database link and use INSERT INTO empmaster SELECT * FROM empmaster@linkname. You can also consider EXPORT/IMPORT.
Re: database copying [message #323968 is a reply to message #323866] Fri, 30 May 2008 03:07 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Previous Topic: Oracle Pipelined Table Function
Next Topic: How to remove not null constraint from a column
Goto Forum:

Current Time: Sun Oct 23 13:49:07 CDT 2016

Total time taken to generate the page: 0.08971 seconds