Re: Cannot DROP a ROLE

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 - 09:44:49 CEST