I usually run full export with ROWS=N on a development database before refreshing it from
production, that way I can always re-create the users and schema objects from that exp dump
file.
$ grep -i 'create role' [dump_file] > create_users.sql
$ grep -i 'create user' [dump_file] >> create_users.sql
$ grep -i '^grant' [dump_file] >> create_users.sql
Once database has been refreshed just run the script against the new database in sqlplus.
SQL> set echo on
SQL> spool create_users.log
SQL> @create_users.sql
SQL> spool off
|