Tuesday, August 2, 2011

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

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.

Reference : http://www.dbaglobe.com/2009/09/how-to-use-as-sysdba-during-expimp.html