Home » SQL & PL/SQL » SQL & PL/SQL » Need help in merging two database (unix(OS))
Need help in merging two database [message #359521] Mon, 17 November 2008 02:15 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Dear All,

Can any one please let me know the methodology/Best practices for merging two databases.
We are having two oracle Database A and B, the data from
Database A has to be migrated to Database B using PL/SQL scripting.

it will be a great help,Thanks in advance!
Re: Need help in merging two database [message #359522 is a reply to message #359521] Mon, 17 November 2008 02:27 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

You mean to say "merging 2 schemas"

Then why can't you Export 2 schemas and import into the Target schema?

Smile
Rajuvan
Re: Need help in merging two database [message #359569 is a reply to message #359521] Mon, 17 November 2008 05:54 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
If both the schema structure is same then you can go for Schema Export and import into target database.

And if the mergring based on some calculation part then, you need to do PLSQL scripting for that.

Thanks,
Previous Topic: Returning a ref cursor with updated contents of a cursor variable
Next Topic: Adding time to a date parameter
Goto Forum:
  


Current Time: Mon Dec 05 21:31:20 CST 2016

Total time taken to generate the page: 0.11840 seconds