title: Oracle Export: ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
body: <p>Im trying to export a .dmp of an oracle database but am getting the follwoing error when I run the exp command</p>
  
  <p>ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM</p>
  
  <p>This is the first time I've tried to export from this server since it has been set up. Is there something I need to do to allow export to function in the correct manner.</p>
  
  <p>THE FULL SOLUTION FOR ME WAS (WINDOWS MACHINE)</p>
  
  <p>1) Open command prompt at C:\Oracle\Ora92\rdbms\admin</p>
  
  <p>2) Logon to sqlplus as sysdba, to do this in command prompt you need to execute command
  sqlplus  "sys as sysdba" </p>
  
  <p>3) Run catexp.sql - this gets rid of some errors
  (to run type @@catexp.sql in command prompt)</p>
  
  <p>4) Run catproc.sql</p>
  
  <p>5) Run catmeta.sql this requires to shutdown oracle, run the patch and restart as described below.</p>
  
  <p>1)logon sqlpus sysdba
  2)shutdown immediate;
  3)startup migrate;
  4)@@catpatch.sql;
  5)Shutdown immediate;
  6)Startup;</p>