CODEWITHSUNDEEP
oracle-databasedatabase-backups
Shahrukh
Shahrukh

Reputation: 1536

How to use Oracle DMP files?

I have some files of an Oracle database with username and password.

How do I connect to all files and browse the data tables and fields. I want to view all my records in them. Do I install Oracle Database server? Or is there a tool on internet to connect with my all files and browse data?

=== Files have .dmp extension ===

Upvotes: 8

Views: 67338

Answers (3)

Ricky
Ricky

Reputation: 29

Two steps to get your data

  1. Install an oracle database
  2. Import the dmp files you had

You can query the data using sql with username and password.

Upvotes: 2

kevinskio
kevinskio

Reputation: 4551

Oracle .dmp files can only be read by Oracle tools. Try installing the free oracle 10g express and use the import command. Or you can use SQL developer which is installed by default with Oracle 10g express or can be downloaded and installed separately.
Either way you need to import the files to an Oracle database to view the files easily.

Upvotes: 8

GolezTrol
GolezTrol

Reputation: 116170

Those .dmp files are data dumps used for backup and recovery. You don't use them as is, but re-import them in your Oracle DBMS.

Upvotes: 4

Related Questions