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:
Any help would be appreciated.Code:
INCLUDE=SYNONYM:"IN(SELECT synonym_name FROM dba_synonyms WHERE 1=0)"
LRM-00116: syntax error at ')' following '0'