Saturday, 13 October 2012

Using sysdba for oracle exp/imp utility



Example:

$ exp userid=\'/ as sysdba\' file=DBEXP.dmp log=DBEXP.log full=y

Use \'/ as sysdba\' to take exp as sysdba (SYS user).