• This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • #1882
      daniesh
      Participant

      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

    • #2041
      Saurabh Sood
      Member

      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!!

    • #2042
      daniesh
      Participant

      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

    • #2043
      Saurabh Sood
      Member

      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

    • #2044
      daniesh
      Participant

      Hi ,

      Sorry for the late reply.

      was out of office.

      I will implement this steps.

      Thanks

    • #2045
      Saurabh Sood
      Member

      Hi Daniesh,

      Please let me know once you are

      through these steps.

      Cheers!!!!!!!

      Saurabh

Viewing 5 reply threads
  • You must be logged in to reply to this topic.