Re: Creating Multiple Users
Date: 1998/04/22
Message-ID: <6hlfki$5g0$1_at_nnrp1.dejanews.com>#1/1
How about this for one choice, put the names(schema names) in a file and using utl_file and dynamic sql, build the sql to do the create user ddl statement.
you could also use the file when getting rid of them by doing a drop user.
just a thought, joe
http://www.oracle-dba.com
In article <353E3F54.505EA8EA_at_email.psu.edu>,
baw128_at_psu.edu wrote:
>
> I need to determine how to enter and remove large numbers of users for
> Oracle several time a year. Does anyone have any ideas on how to
> automate the process to save the time spent entering each user
> individually?
>
> Thank You,
>
> Brad
> baw128_at_psu.edu
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 22 1998 - 00:00:00 CEST