Re: Invalid objects

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Oct 2001 21:41:17 +0200
Message-ID: <tsp3nf8dk0j1b@corp.supernews.com>

Alter <object_type> <object_name> compile

applies to procedures, packages, functions,*views* and *types*

Hth,

Sybrand Bakker
Senior Oracle DBA

"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> 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
>
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail piece of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue Oct 16 2001 - 14:41:17 CDT