DanBrother的部落格

------------------------------------------------------------------
-- Backup Oracle User Account With Password
-- Applied Version: Oracle 9i and up
------------------------------------------------------------------
set long 9999999 trimspool on trimout on
spool c:\user_account_backup.txt
select trim(dbms_metadata.get_ddl('USER', username)) || '/'  as usercreate
from dba_users;
spool off

[Reference]
http://www.oraclealchemist.com/news/trick-1-copying-users-the-right-way/



------------------------------------------------------------------
-- Backup Oracle User Account With Password
-- Applied Version: Oracle 8i
------------------------------------------------------------------
set long 9999999 trimspool on trimout on
spool c:\user_account_backup.txt
select 'create user '||username||' identified by values ''' ||password||''''||
' default tablespace '||default_tablespace||' temporary tablespace '||temporary_tablespace ||';' as create_user
from dba_users
/
spool off