Which user were u dropping?
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:ui5ld549b0mq05_at_corp.supernews.com...
> When you enter the drop user command
> query the v$session_wait view to see what it is waiting on.
>
> We have seen cases where it will wait on a latch that
> another session refuses to give up. We have had to
> disconnect the other session before dropping the user.
> Rebuilding the database was not nexessary.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Steven" <steven.pannell_at_gmx.net> wrote in message
> news:afu8pp$h6jm2$1_at_ID-82797.news.dfncis.de...
> > Hi,
> >
> > I'm attempting to drop a user from a oracle 8.1.6 database on solaris
2.7
> > but when I attempt to do so I get an 'end of communication error'. The
> user
> > contains no objects (these were all removed with the cascade option).
> There
> > is no information in the alert log about the problem.
> >
> > Does anyone have an tips where I can seek out the problem and drop this
> user
> > without rebuilding the database.
> >
> > Thanks in advance,
> > steve.
> >
> >
> >
>
>
Received on Wed Jul 03 2002 - 11:17:43 CDT
