export as SYSDBA in Oracle




 1)   How to export as SYSDBA
         
          exp \'sys/pwd as sysdba\'

  2)  Export using parameter file

          exp parfile=
  
create a file  exp.par  and insert the following line  and other export parameters

          USERID="sys/ as sysdba"



To export   a user must have

CREATE SESSION
EXP_FULL_DATABASE
IMP_FULL_DATABASE


Export utility is created by   CATEXP.SQL
When database is created CATALOG.SQL automatically runs CATEXP.SQL
 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post