How to restore/load dbf to extract data

Question

1.00/5 (1 vote)

See more:

Hey there ,

I have a requirement where I need to load the data from <b>dbf</b> , svd ,arc , ctl ,obk file such that I can run select queries (with complicated joins)to extract the data from these files . These files are provided by 3rd party vendor by taking database back-up of an Oracle 11g database . I have Toad for Oracle software (Version 10.5.1.3), however couldn't accomplish the task . Please let me know if Toad can be used and if yes then how ? If not please suggest a freeware ar anything that will work . I don't have DBA rights on this database .

Your quick help on this is much appreciated.

Posted 12-May-13 1:39am

ohh its true

Updated 12-May-13 8:44am

Sandeep Mewara

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sudhakar Shinde · Answer 1 · 2013-05-12T19:12:00

Solution 1

Even though oracle fetches data from the DBF files, they are NOT a valid backup. The only way to recover the data is to create a new oracle database using the same version that the datafiles were running in and recover the database.Please note that you cannot restore a file without knowing the original structure and this is not an easy task.

Please check if you can get dmp file from vendor instead of dbf files.

Posted 12-May-13 19:12pm

Sudhakar Shinde

Comments

ohh its true 13-May-13 6:21am

Hi Sudhakar ,

Thanks for the quick reply . However , it is not possible to get dmp files from the vendor :( .
Also , I do know the structure of the database (I have permissions to perform the following select,insert,update). Does that help ? Is there no tool to extract the data , somebody had suggested sql server management studio ? etc , Are there no hopes at all ?

Sudhakar Shinde 13-May-13 6:29am

Try recovery option as mentioned above however it is difficult option.

ohh its true 13-May-13 8:16am

okay , we'll try , thanks :)

Jörgen Andersson · Answer 2 · 2013-09-22T05:11:00

Solution 3

Forget using the backup or dbf files. You would need an almost identical setup as the server the files originate from (file system, setup files and user accounts, and probably a lot more.)
The appropriate way to do it on Oracle is to import an export[^] file.

Posted 22-Sep-13 5:11am

Jörgen Andersson