Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Datapump EXCLUDE parameter

Datapump EXCLUDE parameter

From: ktindy <ktindy_at_gmail.com>
Date: Mon, 30 Apr 2007 13:38:20 -0400
Message-ID: <3a5c23940704301038u154e021ch80b11e216902b845@mail.gmail.com>


Does anyone know how to use EXCLUDE at the table level for a full export?

Here is the partial parfile:
directory=dpump_exp_dir
dumpfile=Full.%U.dmp
full=y
logfile=Full.log
exclude=statistics
parallel=4
exclude=schema:"='TEST'"
exclude=table:"='TEST_TAB'"

But say there is a table called TEST_TAB in more than one schema, and I'd like to exclude the table from only one of the schemas.

Thanks!!

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 30 2007 - 12:38:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US