title: SQL - user-management --> export/import users via script
body: <p>The company I'm working at is migrating their databases from Oracle 10g to 11g. On Monday we want to clean our development database and clone the production database to that storage.</p>
  
  <p>Here we go again. My second task is a little bit more complicated I think. On the development database we have got ~200 users and on the production database something like 1500 users. Now I shall write a script that should return all users from our development database and export them. After that another script should search all the users of the production database without any objects and delete them, but non of the system schema or user schema, and import the old users of the development database. Is there a way to do all those things in a script or query?</p>
  
  <p>Best regards,</p>
  
  <p>Chris (IT student, but total database newbie)</p>