drop user gives ORA-00604

Hi,

I'm having the same problem in an existing 8.1.5 database. I just can't drop one of the users (I've dropped and created users before on the same db)

Any ideas?
Thanks
Rishi

In article <38970678.B4681556_at_NOSPAMTHANX.hotmail.com>,   "s. hunter" <sarahxhunter_at_NOSPAMTHANX.hotmail.com> wrote:
> Hello all,
>
> I have just created a brand spanking new database in 8.0.5 (SGI IRIX).
> I've done all the stuff like running catalog.sql, creating
> rollbacksegments and creating a user, but unfortunately I've spelt the
> users name wrong!
>
> So I want to drop the user and create him again, but with the correct
> spelling.
>
> In svrmgrl I connected internal and tried
>
> SVRMGR>DROP USER chros;
>
> I get
>
> ORA-00604: error occured at recursive SQL level 1
> ORA-00942: table or view does not exist.
>
> What the hell is going on? Am I doing something incredibly stupid, or
> what?!
> I haven't even done a grant create session on the guy, so he can't be
> logged in...
> Adding the cascade option doesn't make any difference (as if it
> would!). Anyone want to point out my inadequacies??
>
> Thanks!
>
> Sarah
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 18:59:38 CST