How to use Oracle DMP files?

oracle database-backups
Shahrukh picture Shahrukh · Nov 30, 2011 · Viewed 58.2k times · Source

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 ===

Answer

kevinsky picture kevinsky · Nov 30, 2011

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.

Related questions

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

We are working with Oracle 11g database on Windows 8 and 10 OS environments. We need to dump (backup) database and then restore that dumped file into another oracle database, so we are trying Recovery Manager (RMAN) for it. We issues following …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More