[daniesh]

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

[Saurabh Sood]

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

[daniesh]

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

[Saurabh Sood]

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

[daniesh]

Hi ,

Sorry for the late reply.

was out of office.

I will implement this steps.

Thanks

[Saurabh Sood]

Hi Daniesh,

Please let me know once you are

through these steps.

Cheers!!!!!!!

Saurabh

[Author]

Posts