I have only .dbf datafile(from cold backup, not exported), and must extract two tables from it. Unfortunately, I have no control-files, redo-log files, etc.(only datafile..) How to get tables from datafile? Please teach me..
(If a suitable script exists, Plz tell me where I get it from..)
Answer
You could get some tables out of it using a utility from Oracle called DUL (Data Unloader). However, Oracle charges a premimum for this. Not to buy it, but to have a technician come out and literally rip the data out of the datafiles. I have gone through this process, and it's VERY expensive. From memory, I believe they charge $2400 per hour, with a four hour minimum. Just a thought, if this data is really important, they can get it out.
The unloader is very good if the fileheaders of the tablespaces are damaged due to corruption.Let me tell you that "Dul" is a mighty tool, but if the db blocks are damaged the unloader maybe won't help you but you have to pay the price and that's not
Cheap, believe me.
Another cheap gui dul option is PRM-DULDBRECOVER for Oracle
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.