Hello,

I am trying to import a database excluding public synonyms using impdp. A colleague gave me the following line to add to my impdp command, but it results in a syntax error:
Code:
INCLUDE=SYNONYM:"IN(SELECT synonym_name FROM dba_synonyms WHERE 1=0)"

LRM-00116: syntax error at ')' following '0'
Any help would be appreciated.

Thank you.