Oracle: Export tables with the exp command and a parfile

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



Let’s name this file ‘export.conf’


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. URL - trackback on October 19, 2012 at 06:37

Leave a Comment

NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre lang="" line="" escaped="" cssfile="">

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trackbacks and Pingbacks:

  • URL - Trackback on 2012/10/19/ 06:37