Adding datafile This topic contains 5 replies, has 0 voices, and was last updated by daniesh 10 years, 8 months ago. Author Posts 12 January, 2009 at 10:19 am #1882 danieshParticipant 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 13 January, 2009 at 4:58 am #2041 Saurabh SoodMember 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!! 13 January, 2009 at 5:54 am #2042 danieshParticipant 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 13 January, 2009 at 7:12 am #2043 Saurabh SoodMember 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 19 January, 2009 at 6:13 am #2044 danieshParticipant Hi , Sorry for the late reply. was out of office. I will implement this steps. Thanks 19 January, 2009 at 3:05 pm #2045 Saurabh SoodMember Hi Daniesh, Please let me know once you are through these steps. Cheers!!!!!!! Saurabh Author Posts You must be logged in to reply to this topic.