How to load /restore dbf to extract data using select queries
1008469May 13 2013 — edited May 13 2013Hey there ,
I had asked for database(Oracle 11g) back-up files (for a particular date)from a third party vendor. The files I received were with the following extensions : .dbf , .svd , .arc , .ctl .
They cannot provide it any other format .
Now my concern is : How can I load/restore data from these files such that I can run some select queries(with lcomplicated joins) so as to extract the data from the files which can be shared with the requestor .
Please let me know iif any freeware/beta version tool can be used to do the same ? If yes then please advise the tool along with procedure to complete the above task . Please note I don't have DBA rights for this database as third party vendor is maintaining it . However , I have permissions on this database to select / insert/update data in the database .
Your quick help on this is much appreciated .
Also , let me know the file with which of these extensions (dbf,svd,arc,ctl) will contain the data extractable through select queries .