Re: copying users from one Instance to another

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: 1998/06/23
Message-ID: <un$q$hyn9GA.259_at_upnetnews05>#1/1


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 CEST

Original text of this message