Thursday, August 12, 2010

How to use “/ as sysdba” to export and import

  1. For  windows  platforms

    exp userid=”"”/ as sysdba”"” file=export.dmp ...
    imp userid=”"”/ as sysdba”"” file=export.dmp ...
  2. For  Unix  paltforms

    exp userid=\’/ as sysdba\’   file=export.dmp ...
    imp userid=\’/ as sysdba\’  file=export.dmp ...

     

No comments: