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.

Report message to a moderator

Previous Topic: filesize in expdp /impdp
Next Topic: Getting error at Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 11:28:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.