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
1 Comments.