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.

Niklas Tech Blog
Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.