Oracle: Export tables with the exp command and a parfile

Posted by on July 1, 2011

This is an example of an export of selected tables with the Oracle DB command exp:

Parfile:

BUFFER=100000
TABLES=(table1,table2,table3)
FILE=/path/to/exportfile.dmp
LOG=/path/to/logfile.log

Let’s name this file ‘export.conf’

Command:

exp <user>/<password>@<sid> PARFILE=export.conf

This will export all data needed to recreate the tables: table1, table2 and table3 into exportfile.dmp. This file can later be used with the imp command to restore the tables

To see more options of the exp command try:

exp help=y

This will show you a list of commands and settings

Databases

Comments are closed.