11 Replies Latest reply: Aug 10, 2009 11:05 AM by gpafogarty RSS

    Copying Oracle User Accounts from One Database to Another

      I regularly export a particular schema from a production database and import it into a test database. One of the tables in the schema contains usernames, along with information on the user's employer. On the production database an Oracle account exists for each user in the table. The application that inserts rows in the table also executes a "create user" statement.

      When I import the schema into the test database there is no corresponding "create user" done for each user in the table. So, the Oracle accounts in the test database do not match the contents of the newly imported table of users.

      Is there a way to use an Oracle utility to copy the account information for Oracle users from my production database to my test database?

      Thank you,