Phone: +86 13764045638 Email: firstname.lastname@example.org 7 x 24 online support!
My database is crash.I have only one datafile of billing.
I have oracle 11g release 2.
My database is crash.I have only one datafile of billing.in which all important information is store.
I do not have dump.I have only one .dbf file.
Now i want to use this file when i create new database to regenerate data.
but how can i use that datafile?
As long as there is an intact datafile, there is hope :-)
But there is indeed no easy way to get your data back. As Aman suggested, contact Oracle Support immediately.
Do not try to resolve this by yourself resp. by some clever advices from the internet!
Oracle Support has utilities like DUL to read your datafile without accessing it through an instance.
PRM-DUL is another alternative recovery unload tool can be find here : http://www.parnassusdata.com/en/oracle-dul