I have a .dmp file that probably contains the entire database. How can I get to know and extract the data out of this .dmp file about which I don't know much? I am using Oracle8i for Windows XP and I have to connect this database to some dynamic Web page thereafter.
Well you can create a log file from the .dmp file without importing the database. For example, say your .dmp file is called maybe_full_database_exp.dmp; on the command line you can type,
imp full=y file=maybe_full_database_exp.dmp show=yes log=I_NEED_TO_KNOW.log
The log file will have the entire content listing of the maybe_full_database_exp.dmp file in the I_NEED_TO_KNOW.log file. You can open the log file using NOTEPAD.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
There are several ways to back up a database, including schema, table and full exports, as well as hot and cold backups. Here are descriptions of ... Continue Reading