Mohammed,

I don't know if anyone replied to you but the following code will create
a script wit all the users and passwords (encoded) that you can run after
the refresh. Hope this helps you,

Rob

SET HEAD OFF
SET VERIFY OFF
SPOOL reset_passwords.sql

SELECT 'alter user '||username||' IDENTIFIED BY VALUES
'||''''||password||''''||';'
FROM sys.dba_users
/

SPOOL OFF
SET HEAD ON
SET VERIFY ON
Oracle LazyDBA home page