title: Oracle SQL Developer copy database step by step
body: <p>I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as a development DB.</p>
  
  <p>I'm used to SQL Server, I'm new to Oracle (11g).</p>
  
  <p>I wanted to use the 'Database copy' from SQL Developer, but I'm getting errors all the way. First it was about missing tablespaces.
  Then when I manually created them in my new empty DB the errors were about missing users.
  I wanted to create the users manually, but then I first needed to create missing roles.
  When all that was done, it failed on missing indexes...</p>
  
  <p><strong>How do I copy everything I need with 'Database copy'?</strong></p>
  
  <p>Any advice is greatly appreciated!</p>