Home » Other » General » Database Merging (Oracle 10.2.0)
Database Merging [message #594948] Wed, 04 September 2013 07:18 Go to next message
fishydave1
Messages: 4
Registered: September 2013
Junior Member
I am completely new to databases Shocked and Oracle but have been tasked with merging two dBs, which have identical tables but different data - is there an easy/straight-forward way to perform this task so that all data is available from the one dB?
Re: Database Merging [message #594958 is a reply to message #594948] Wed, 04 September 2013 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Data Pump.

Regards
Michel
Re: Database Merging [message #594968 is a reply to message #594948] Wed, 04 September 2013 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 23070
Registered: January 2009
Senior Member
>is there an easy/straight-forward way to perform this task so that all data is available from the one dB?
NO, no easy way; especially for anyone who does not know database to begin with.
Re: Database Merging [message #594997 is a reply to message #594968] Wed, 04 September 2013 13:51 Go to previous messageGo to next message
Littlefoot
Messages: 19824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you are new to Oracle: are these really two databases, or do you have two schemas (within the same database)?
Re: Database Merging [message #595015 is a reply to message #594997] Thu, 05 September 2013 01:31 Go to previous messageGo to next message
fishydave1
Messages: 4
Registered: September 2013
Junior Member
Both were generated from separate import dmp files into db1 and db2 - I want to be able to merge the data from both db1 and db2 into a new db3 - I believe the schema is the same for both db1 and db2 (i.e. the same tables etc but with differing data).
Re: Database Merging [message #595016 is a reply to message #595015] Thu, 05 September 2013 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 04 September 2013 15:52
Michel Cadot wrote on Wed, 04 September 2013 14:44
Data Pump.

Regards
Michel



Do it twice.
Re: Database Merging [message #595017 is a reply to message #595016] Thu, 05 September 2013 02:10 Go to previous messageGo to next message
fishydave1
Messages: 4
Registered: September 2013
Junior Member
I assume on the first import I do a FULL import and then on the second only the data (using the CONTENT parameter)?
Re: Database Merging [message #595027 is a reply to message #595017] Thu, 05 September 2013 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59822
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SCHEMAS parameter to only export your schemas.
Use TABLE_EXISTS_ACTION=APPEND on the second import.

Regards
Michel
Re: Database Merging [message #595199 is a reply to message #595027] Mon, 09 September 2013 03:28 Go to previous messageGo to next message
fishydave1
Messages: 4
Registered: September 2013
Junior Member
A few steps forward and several back!
On the second import I get multiple ORA-31693 errors, which I presume is due to identical data within a table, unfortunately the 'new' data within the table gets skipped and the process continues onto the next table. Perhaps I did not explain myself too well in the first place, I have two dB export files which has a lot of common data between them, but each table may/may not have slight differences - how can I get round loading data from these tables without the import skipping them.
Re: Database Merging [message #595200 is a reply to message #595199] Mon, 09 September 2013 03:44 Go to previous message
gazzag
Messages: 367
Registered: November 2010
Location: Bristol, UK
Senior Member
As Michel said, look into the TABLE_EXISTS_ACTION parameter of DataPump.
Previous Topic: Applying CPU patch on version 11.2.0.3
Next Topic: Oracle 6.0
Goto Forum:
  


Current Time: Sat Nov 29 00:33:03 CST 2014

Total time taken to generate the page: 0.10717 seconds