Invoking EXP & IMP as “SYSDBA”

Here is the procedure to invoke EXP & IMP as ” SYSDBA “

FOR WINDOWS :

(a)Import

C:\>IMP ‘username/password as sysdba’ keyword=(value1,value2,….valuen)

Example:C:\>IMP ‘sys/sys as sysdba’ fromuser=hr touser=abc file=export2.dmp owner=hr

(b)Export

C:\>EXP ‘username/password as sysdba’ keyword=(value1,value2,….valuen)

Example: C:\>EXP sys/sys as sysdba’ file=export2.dmp owner=hr direct=y

FOR LINUX :

(a)Import

C:\>IMP \’username/password as sysdba\’ keyword=(value1,value2,….valuen)

Example:C:\>IMP \’sys/sys as sysdba\’ fromuser=hr touser=abc file=export2.dmp owner=hr

(b)Export

C:\>EXP \’username/password as sysdba\’ keyword=(value1,value2,….valuen)

Example: C:\>EXP \’sys/sys as sysdba\’ file=export2.dmp owner=hr direct=y

Note :

For Remote Access ,we can use like this

C:\>IMP ‘username/password@instance as sysdba’ keyword=(value1,value2,….valuen