Phone: +86 13764045638 Email: firstname.lastname@example.org 7 x 24 online support!
Merge data from oracle .dbf datafile
Hi, i need a help.
I'm totaly new to oracle.
I currently have database server wich had an error so i create another server that runs for some times and have data in it too. Now i want to merge the data from the old database tho the new database wich have excatly the same name, structure and schema with the old one. The problem is i only have the .dbf file from the old database while the new one is running fine.
Can anyone help me? Thanks
In general it is not possible to work only with datafiles. You need to to have a running database in order to be able access data and merge it.
If you have all datafiles and controlfiles from a consistent backup you should try to restore and restart this database.
If you this is not possible there are some specialized tools to work directly on datafiles like PRM-DUL and DUL from specialized companies; Oracle Support can also help in this case.
PRM-DUL can be find here : http://www.parnassusdata.com/en/oracle-dul