Also, as sys/internal utlrp.sql, catexp7.sql & utlconst.sql. Spool
utlconst.sql to list all invalid constraints found.
HTH
tED
holmesb_at_my-dejanews.com wrote in message
<75349b$sdu$1_at_nnrp1.dejanews.com>...
>In article <752tnc$t2u3_at_news.hk.linkage.net>,
> "Robert Edgar" <robedgar_at_hkstar.com> wrote:
>> I have just completed updating both our test and production servers from
>> Oracle 73352 to 805 and we have a couple of problems that have me more
than
>> a bit worried.
>>
>> I noticed under SYS a view ALL_FK_CONSTRAINTS_2 is not valid. Seems the
view
>> is trying to access a columns "type" in table sys.cdef$ but on checking
the
>> column is called type#.
>>
>> There is no other view called ALL_FK_CONSTRAINTS so is this a serious
>> problem.
>>
>> Secondly since upgrdading I can find no archivelogs have been produced
>>
>> Thirdly the database seems very very slow, a query that normally would
come
>> back instantly is taking a minute or so...
>>
>> Seems something is screwed up somewhere...
>>
>> Any thoughts on how to fix this...
>> Rob
>>
>>
>
>Did you run catalog.sql, catproc.sql, catexp.sql? One usually needs to run
>these after an upgrade/patch.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Dec 14 1998 - 11:49:54 CST
