Adding datafile

This topic contains 5 replies, has 0 voices, and was last updated by  daniesh 10 years, 8 months ago.

  • 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

You must be logged in to reply to this topic.