Adding Users

 PT> From: Priya Tantry <tantry_at_cc.uq.oz.au>

 PT> What is the best way of adding users to Oracle in bulk on Unix?

If you already have them defined as unix users, Oracle can let the OS handle the login and stuff. See OPS$ or OS_AUTH_PREFIX in the docs.

The other way is to use a shell script. One problem I have run into in the past is it is possible to overwhelm the DB writer by jamming too many add user statements down its throat, so you might want to put in some sleep statements if you have some loop in a shell script reading a huge datafile.

Of course, the real answer is, "it depends."

jg

--
Standard disclaimer: The views of this user are strictly his own.