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
Decivox
Messages: 1
Registered: December 2010
Junior Member
Hello,

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 Sep 17 07:38:57 CDT 2021