Re: help: Invalid objects

From: Nirmal <nsingh49_at_hotmail.com>
Date: 17 Oct 2001 09:04:08 -0700
Message-ID: <f6720ba7.0110170804.56930c39@posting.google.com>

u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote in message news:<l.1003154644.1334411621@[64.94.198.252]>...
> Hi, We are using oracle 8.1.7 on solaris 7, we are having several
> invalid objects.
>
> OWNER OBJECT_NAME OBJECT_TYPE
> -----------------------------------------------
> SYS _ALL_REPCOLUMN VIEW
> ORDSYS ORDANNOTATIONS TYPE BODY
> CTXSYS CONTAINS OPERATOR
> CTXSYS CONTEXT INDEXTYPE
> CTXSYS SCORE OPERATOR
> When I issue "drop view _ALL_REPCOLUMN"; I got
> SQL> drop view _ALL_REPCOLUMN;
> drop view _ALL_REPCOLUMN
> *
> ERROR at line 1:
> ORA-00911: invalid character
> How should I deal with this? And could you tell me how I should deal
> with invalid "type body" and "operator" and "indextype"?
>
> Thanks

Try to recompile the invalid objects....

Nirmal Received on Wed Oct 17 2001 - 11:04:08 CDT