impdp exlude=table:
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