Re: Cannot DROP a ROLE

If you don't want to experience new problems, make sure you have EXACTLY 1 row in DUAL. If you don't have any value there, issue "insert into dual values ('X')" as user SYSTEM.

Daniel

Miko_at_boehrer.de (Ralf) wrote in message news:<fa624200.0304072344.86812f7_at_posting.google.com>...
> Hi TC,
>
> Thanks for your help.
>
> select count(*) from dual;
> has as result: 4
>
> After I truncated the dual-table, the dropping of roles worked fine.
> What can be the reason of getting 4 rows in dual ?
> How many rows are normal for dual ?
>
> Thank you for your hint.
> Ralf
>
>
>
> "TC" <donotuse_at_donotuse.com> wrote in message news:<RPhka.395955$S_4.464063_at_rwcrnsc53>...
> > How many rows do you have in dual ?
> >
> > select count(*) from dual;
> >
> > Just a thought
> >
> > //tc
> >
> > "Ralf" <Miko_at_boehrer.de> wrote in message
> > news:fa624200.0304070429.26a87438_at_posting.google.com...
> > > Hi to all,
> > >
> > > I want to execute the following SQL-statement in SQL-Plus.
> > > "DROP ROLE AAA_ROLE;"
> > >
> > > But it doesn't work.
> > > I get the following error:
> > > "ORA-00604: error occurred at recursive SQL level 1"
> > > "ORA-01422: exact fetch returns more than requested number of rows"
> > >
> > > What did I make wrong ?
> > >
> > > Thanks in advance for any help or comment.
> > > Ralf
Received on Tue Apr 08 2003 - 20:27:22 CEST