Q

Extracting data from .dmp file

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.

This was first published in June 2004

Dig deeper on Using Oracle PL-SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close