Re: Cannot drop function

You can rename a table, i'm not sure if you can rename a iew. Try it then try dropping the function.

M

<pbeatty_at_my-deja.com> wrote in message news:7t23lt$n0h$1_at_nnrp1.deja.com...
> I have a function(and a view) in Oracle 8.0.5 that
> I cannot drop. The function calls a view which
> calls the same function. Both are invalid.
> I have also tried to replace both with a new
> function/view of the same name.
> Trying to drop either gives ORA-00600.
> Is there a way to get get these out of the
> database?
>
> Thanks in advance.
>
> Paul
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 01 1999 - 06:46:48 CDT