Exporting Oracle database Tables using exp utility

To export Oracle Database Tables the exp utility can be used. The utility is available on the
Oracle Database machine typicalliy in the following directory $ORACLE_HOME/bin. The following command can be used to export a (selective list) of Database tables:

exp user/password file=filename.dmp tables=Table1,Table2

imageThe exp utility displays the current progress in the terminal:

image
After completion the exported file can be found in the directory where the utility has been executed:
image

Advertisements

determining the path for Oracle data files (dbf)

The following command can be used (as SYSDBA) to determine the hard drive location of the Oracle data files (dbf):

image

SELECT DISTINCT SUBSTR (file_name,
1,
INSTR (file_name,
'/',
-1,
1))
FROM DBA_DATA_FILES
WHERE tablespace_name = 'SYSTEM';