Re: copying users from one Instance to another

If the users are already created in the second database, try to run this script on the first database and generate a script file to run on the second database.

1. On first database.

set echo off feedback off pages 0
spool alt_user.sql
select 'alter user ' || username || ' identified by values ' || password ||';'
from dba_users;
spool off

2. Run alt_user.sql on the second (new) database. Received on Tue Jun 23 1998 - 00:00:00 CDT