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
rajboopin
Messages: 7
Registered: December 2007
Location: INDIA
Junior Member
hi,


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
boopathi
Re: database copying [message #323866 is a reply to message #323865] Thu, 29 May 2008 21:44 Go to previous messageGo to next message
ebrian
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
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_DATAPUMP perhaps?
Previous Topic: Oracle Pipelined Table Function
Next Topic: How to remove not null constraint from a column
Goto Forum:
  


Current Time: Sat Dec 03 12:14:31 CST 2016

Total time taken to generate the page: 0.18254 seconds