title: Import Oracle schema with SQL Developer
body: <p>I exported a database schema from one server using SQL Developer (Tools-> Database Export). It generated a script, but I have problems executing it on another server. </p>
  
  <p>The schema has a number of triggers/procedures and I got an error (<code>ORA-00942: table or view does not exist</code>) creating the first multi-statement trigger(or sp). It works properly if I execute each <code>CREATE TRIGGER</code> separately, but it's quite a tedious process ...  </p>
  
  <p>I believe it is because of the semicolon between statements in the trigger body, but I don't know how to make it work. What is the right way to execute the script?</p>
  
  <p><strong>[UPDATE]</strong><br>
  Just in case if someone else has a similar problem, don't forget to switch to a newly created schema <code>ALTER SESSION SET CURRENT_SCHEMA=NEW_SCHEMA_NAME;</code> in the beginning of import script. </p>