ORA-39071: Value for EXCLUDE is badly formed.

Oracle Database 101

Quick post more for myself as I seem to continually forget how to construct a proper EXCLUDE on the command line (no parameter file) on Linux with DataPump so here it is .

"exclude=SCHEMA:"IN('SCHEMA1','SCHEMA2')""

And yes the quotes before exclude and at the very end are required. This of course isn’t the only way but hopefully one I can remember.

View original post

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s