AskDBA.org Forum Forum for Oracle DBA's

About This Topic

• Posted 3 years ago
• By daniesh
• Latest reply from Saurabh Sood
• This topic is not a support question
• RSS feed for this topic

Tags

No tags yet.

1. 

   daniesh
   

   member
   Joined: Nov '08
   Posts: 29

   offline

   Reputation:41

    

   
   Posted 3 years ago
   #

   Hi All,
   I need to make two database into one.
   I have two prod databases esgprod eagprod.
   the client want to make to merge both the databases.
   Could you please suggest me the steps?

   Thanks
2. 

   Saurabh Sood
   

   admin
   Joined: Jun '08
   Posts: 46

   offline

   Reputation:48

    

   
   Posted 3 years ago
   #

   Hi Daniesh,

   The easiest way is to take export dump of one prod database and then import
   that into other prod database.

   First of all check all the tablespace names existing in one database and then pre-create these tablespaces into other database and then you can start the import.

   Cheers!!

   Saurabh Sood
   Senior Consultant:DBA Services
3. 

   daniesh
   

   member
   Joined: Nov '08
   Posts: 29

   offline

   Reputation:41

    

   
   Posted 3 years ago
   #

   Hi Aarya,

   Thanks for the reply.
   I am a bit confused i have to make changes in the control of target database i think.
   otherwise how oracle will know that new tablespace and datafile has been added to the
   target database.

   Thanks,
   Daniesh
4. 

   Saurabh Sood
   

   admin
   Joined: Jun '08
   Posts: 46

   offline

   Reputation:48

    

   
   Posted 3 years ago
   #

   Daniesh,

   Let us suppose that you want to merge esgprod to eagprod.

   1. check all the tablespace name on esgprod database.
   2. create those tablespaces on eagprod database.
   3. Take export of esgprod database.
   4. import the data into eagprod database using export dump file.

   You need not to make any changes to controlfile manually.

   Cheers!!!
   Saurabh
5. 

   daniesh
   

   member
   Joined: Nov '08
   Posts: 29

   offline

   Reputation:41

    

   
   Posted 3 years ago
   #

   Hi ,
   Sorry for the late reply.
   was out of office.
   I will implement this steps.

   Thanks
6. 

   Saurabh Sood
   

   admin
   Joined: Jun '08
   Posts: 46

   offline

   Reputation:48

    

   
   Posted 3 years ago
   #

   Hi Daniesh,

   Please let me know once you are
   through these steps.

   Cheers!!!!!!!
   Saurabh