Need help in merging two database [message #359521] |
Mon, 17 November 2008 02:15  |
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 #359569 is a reply to message #359521] |
Mon, 17 November 2008 05:54  |
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,
|
|
|