Hi,

We could login as sysdba
drop the user perfstat with cascade option
then re-create with the spcreate.sql

Regards
Ramesh L


>From: Anu <[Email Address Removed] [Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: Dropping a User
>Date: Fri, 30 Jan 2004 09:18:54 -0800 (PST)
>
>First lock out the user so no new connections are made (DBA_JOBS etc).
>Then kill all existing connections
>Wait for them to get killed.
>
>"Deepa S. Kale" <[Email Address Removed] wrote:
>
>remember u hav to log in as sysdba to kill perfstat session...
>or best way is u startup in restrcted mode and run spdrop ....
>
>Deepa Kale -DBA
>Jyoti Structures - Nasik(IT)
>
>
>
>knm dibba
>
>com> cc:
>Subject: Re: Dropping a User
>01/30/2004 05:22
>AM
>
>
>
>
>
>
>Hi
>to kill the sessions connected as perfstat, query v$session. and
>get the sid,serial# from v$session and then give the 'alter system kill
>session' sql and then u will be able to run the spdrop script.
>
>thanks
>Bill Ducker wrote:
>I'm trying to install STATSPACK, and it's not going well. The immediate
>problem is that the uninstall script, spdrop, won't run successfully
>because the user, PERFSTAT, refuses to be dropped. Here's the error:
>
>ORA-01940: cannot drop a user that is currently connected
>
>Do anyone know how I can disconnect this user, short of bouncing the
>database? TIA
>
>William L. (Bill) Ducker
>Database Adminstrator
>Oracle 9i
>ADABAS 7.1.2
>Texas Workers' Compensation Commission
>bill.[Email Address Removed] 804-4974
>
>--- Any opinions in this message are mine, and do not
>represent official TWCC policy.
>
>
>--------
>Get today's cartoon: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:
>http://www.lazydba.com/legal.html
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! SiteBuilder - Free web site building tool. Try it!
>
>
>
>
>
>--------
>Get today's cartoon: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! SiteBuilder - Free web site building tool. Try it!

_________________________________________________________________
Play the prediction game on MEZ. Win Sehwag’s autographed T-shirts.
http://go.msnserver.com/IN/41491.asp Predict and win on myenjoyzone.com.

Oracle LazyDBA home page