All geek questions in one place

How to use Oracle DMP files?

I have several Oracle database files with username and password.

How to connect to all files and view data tables and fields. I want to view all my entries in them. Install Oracle Database Server? Or is there a tool on the Internet to connect to my files and view data?

=== Files have the extension .dmp ===

+4
source share
3 answers

Oracle.dmp files can only be read by Oracle tools. Try to install the free oracle 10g express and use the import command, Or you can use the SQL developer , which is installed by default using Oracle 10g express or can be downloaded and installed separately.
In any case, you need to import files into the Oracle database to easily browse files.

+4
source

Two steps to get your data.

  • Install oracle database
  • Import the dmp files you had.

You can request data using sql with username and password.

+3
source

These .dmp files are data dumps used for backup and recovery . You do not use them as is, but re-import them into Oracle DBMS.

+2
source

Source: https://habr.com/ru/post/1383879/

More articles:


All Articles