I think, you have to use the DROP USER user_name command.

Ram Srinivasan
PRA International, Inc.
4105 Lewis & Clark Drive
Charlottesville, VA 22911-5801
Tel: (434) 951-3365
Web: www.praintl.com


-----Original Message-----
From: Derek Nkansah [mailto:[Email Address Removed] Thursday, February 28, 2002 10:10 AM
To: LazyDBA.com Discussion
Subject: Oracle 7.3


Hi,

I know this might not be true but is it true that the capacity for 7.3 is
65,000 users and that you cannot delete users from this??

It sounds a bit ludicrous but then anything is possible. The sticking point
is, can defunct users be deleted and if so, how?? Is there a special way or
the usual "drop user" command??

Please help!

Derek


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page