Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Using Oracle PL-SQL

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close