Database Administration (MOSC)

MOSC Banner

impdp exlude=table:

edited Nov 25, 2015 10:02AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

I need to exclude exactly one table from a dumpfile.

The dump contains data from several schemas, and the table to be excluded exists in several schemas.

So the exclude syntax must consist of schema AND table.

I tried:

EXCLUDE=TABLE:"'SCHEMA_NAME'.'TABLE_NAME'"

EXCLUDE=TABLE:'SCHEMA_NAME'.'TABLE_NAME'

EXCLUDE=TABLE:"(:'SCHEMA_NAME'.'TABLE_NAME')"

but the result is always

ORA-39001: invalid argument value

ORA-39071: Value for EXCLUDE is badly formed.

does anybody know the correct syntax?

br

Daniel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center