Monday, September 14, 2009

How to use "/ as sysdba" during exp/imp

On Windows platform:

userid="'"/ as sysdba"'"
or
userid="""/ as sysdba"""

On Unix Platform:

userid=\'/ as sysdba\'

These tricks can be used with Oracle datapump (expdp/impdp) as well.