Hi all,
Thanks for responding. I did run the script outlined below. The invalid
objects are triggers. If I try to compile manually I get the following:
SQL> alter TRIGGER SCER10.VRSS_BRI compile ;
alter TRIGGER SCER10.VRSS_BRI compile
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01405: fetched column value is NULL
These were all valid prior to the upgrade so maybe its code related????
Thanks again
Fawzia
-----Original Message-----
Sent: 01 August 2001 17:26
To: Multiple recipients of list ORACLE-L
What type errors are you getting? That may help in determing if you need to
run some Oracle scripts.
Rick
-----Original Message-----
Sent: Wednesday, August 01, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are invalid. I
have tried to recompile them to no avail. I did the upgrade manually running
the script :u0800050. Is there anything else I needed to run???
Rgds
Fawzia
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
This message is confidential and is intended for the addressee only; unless clearly
stated that this disclaimer should not apply, this e-mail is not intended to create
legally
binding commitments on behalf of any company in the British Interactive Broadcasting
Holding Limited group, nor do its contents reflect the corporate views or policies of
any
such company. Any unauthorised disclosure, use or dissemination, either whole or
partial, is prohibited. If you are not the intended recipient of the message, please
notify
the sender immediately.
