OraFAQ Forum: Server Utilities » EXPDP: how exclude table

Home » RDBMS Server » Server Utilities » EXPDP: how exclude table (Oracle Database 11gR2 (11.2.0.1.0) on Red Hat Enterprise Linux Server release 6.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXPDP: how exclude table [message #542326]

Mon, 06 February 2012 10:45

maxranzy
Messages: 5
Registered: December 2010
Location: Milan (Italy)

Junior Member

Hi,

I tried to export a schema excluding some table, but expdp exit with this error:

ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00936: missing expression

The command that I use is:

expdp system/password@ORADB directory=EXPORT_ORA_DIR schemas=maxdb logfile=maxdb.log 
dumpfile=maxdb.dump EXCLUDE=TABLE:"IN ('max_table_1','max_table_2')";

Where I made a mistake?

Tks
Max

[Updated on: Mon, 06 February 2012 12:28] by Moderator

Report message to a moderator

Re: EXPDP: how exclude table [message #542328 is a reply to message #542326]

Mon, 06 February 2012 11:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Where I made a mistake?
trying to do it in single command line
place all command line arguments except username/password inside control file;
so results are not impacted by OS command line parsing

Report message to a moderator

Re: EXPDP: how exclude table [message #542338 is a reply to message #542328]

Mon, 06 February 2012 12:30

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

..and (which has nothing to do with the current error) give the name of the excluded tables in UPPER case.

Regards
Michel

Report message to a moderator

Previous Topic:	IOT table restoration
Next Topic:	Running into issues when using TOAD to load data using SQL Loader Wizard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:02:12 CST 2025