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)
EXPDP: how exclude table [message #542326] Mon, 06 February 2012 10:45 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
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
Re: EXPDP: how exclude table [message #542338 is a reply to message #542328] Mon, 06 February 2012 12:30 Go to previous message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: IOT table restoration
Next Topic: Running into issues when using TOAD to load data using SQL Loader Wizard
Goto Forum:
  


Current Time: Sat Nov 22 19:20:44 CST 2014

Total time taken to generate the page: 0.05359 seconds