Home » RDBMS Server » Server Utilities » How to exclude public synonyms (Oracle 11, Windows Server 2003)
How to exclude public synonyms [message #486319] Tue, 14 December 2010 15:14
Messages: 1
Registered: December 2010
Junior Member

I am trying to import a database excluding public synonyms using impdp. A colleague gave me the following line to add, but it results in a syntax error:

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.
Previous Topic: filesize in expdp /impdp
Next Topic: Getting error at Import
Goto Forum:

Current Time: Fri May 24 17:36:27 CDT 2024