Database Error

[Upeshp]

Hello Friends,

Oracle 8.0.4 OS - Tru64Unix

Today suddenly an error was reported by users. The error was "database error". When i checked at DB level all Procedures, Functions , some views and Pakages showing "INVALID" status. This had happend in many schema including SYS & SYSTEM.

To overcome the problem I complied the invalid objects and then it was OK.

I want to find out the cause of the problem. Can Anyone suggest me what could be the reason of this problem ??

How come so many objects of database becomes INVALID??

An urgent Help is solicited.

Thanks,

UpeshP

[TimHall]

If you altered a table, package header, procedure or function all referencing code will be invalidated. Once the code is called it should immediately be revalidated. In some cases, the chain of depencies is so long that you get errors until you compile them. Check what happened on the system before this was done.

Cheers

[Upeshp]

Hi Tim,

What i have understood from your reply is, you want to say that any user might have alter the table, package header, procedure or function ?


My problem is How to find out ? Nothing is there in trace file.

Thanks

[TimHall]

Check out the LAST_DDL_TIME column on the DBA_OBJECTS view. This might give you some ideas.

Cheers

[oravijay]

Hi,

Unless you turn on tracing(in the userlevel) or audit the activities of the database, you don't have much options for finding the user activity.

As Tim said you will have to look at last_ddl_time for getting some idea.

HTH.
Vijay.

[Upeshp]

Thanks,

Tim, Vijay for solution.

Any one want to comment more on this problem ??

UpeshP