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: get error through FORMAT_ERROR_BACKTRACE
Next Topic: SQL for linking Oracle GL accounts to Oracle Projects
Goto Forum:

Current Time: Sun Aug 20 14:21:16 CDT 2017

Total time taken to generate the page: 0.01602 seconds