April 15, 2014

Export Import with sysdba user

Fellows just little share, really use full if you guys dealing with export import

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.