help: Invalid objects

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Mon, 15 Oct 2001 14:04:02 GMT
Message-ID: <l.1003154644.1334411621_at_[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 Mon Oct 15 2001 - 16:04:02 CEST