Wednesday, May 2, 2012

export public synoymns during schema export

During a schema export the public synoymns are not captured.
So is there a way to get them during a schema export
The answer is yes although it took some while.

In a parfile it will look like this

userid="/ as sysdba"
DIRECTORY=CONVERT_DIR
SCHEMAS=BAO4_OWN,BAO4_USR
FULL=yes
INCLUDE=SYNONYM:"IN(SELECT synonym_name FROM dba_synonyms WHERE owner = 'PUBLIC' and table_owner='BAO4_OWN'
dumpfile=exp.dmp
logfile=exp.log

That is the way to capture public synoyms during a schema export.

No comments:

Post a Comment