How To Transfer Passwords Between Databases (ref note: 199582.1)

fix:

1) Log on as SYSDBA

2) Create database link between source and target database

3) Create procedure which selects usernames,passwords

from DBA_USERS in source database and inserts usernames,passwords

into target database

Sample SQL-statements

source database:

SQL> select password from dba_users where username=’SCOTT’;

USERNAME PASSWORD

—————————— ——————

SCOTT F894844C34402B67

target database:

Sqlplus> Create user SCOTT identified by values ‘F894844C34402B67’;