Re: Cannot DROP a ROLE

Make sure that
select count(*) from dual;
still returms one

If not,
insert into dual values('X');

//tc

"Ralf" <Miko_at_boehrer.de> 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 - 18:12:58 CEST