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?

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Data Pump.

Regards
Michel

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

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: 21823
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)?

Report message to a moderator

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).

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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.

Report message to a moderator

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)?

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SCHEMAS parameter to only export your schemas.
Use TABLE_EXISTS_ACTION=APPEND on the second import.

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Re: Database Merging [message #595200 is a reply to message #595199] Mon, 09 September 2013 03:44 Go to previous message
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
As Michel said, look into the TABLE_EXISTS_ACTION parameter of DataPump.

Report message to a moderator

Previous Topic: Applying CPU patch on version 11.2.0.3
Next Topic: Oracle 6.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 22:51:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.