title: Import and Export Data plus schema using SQLDeveloper 3.0.04
body: <p>i am newbie to oracle and i like to export database from remote database and import it on local machine. eOn both machines i have oracle 10.2.</p>
  
  <p>I need to know how to export/import schema and data from oracle 10.2 using SQLDeveloper 3.0.0.4.</p>
  
  <p>To export from remote database, i have used export Tool-> Database Export ->  export wizard.
  and at the end i have got only sql file with DDL and DML statements but somewhere in file it is written</p>
  
  <pre><code>"Cannot render Table DDL for object XXX.TABLE_NAME with DBMS_METADATA attempting internal generator error. 
  </code></pre>
  
  <p>I have ignored previously mentioned message and tried to run those DDL and DML statements but all this ended up with errors.</p>
  
  <p>Is it possible that all this tied with read-only database user?  More over, i dont find any table under tables but also tables under other users in SqlDeveloper.</p>
  
  <p>Thanks in advance</p>