Alert log doesn't have timestamp

[vr76413]

Hello all..

ORacle 9.2/sun 5.8

I was looking into alertlog and i see some errors, but it doesn't say at what time those errors occured or on which date they happened ?...

how do we find that out ?...


any help is appreciated.

Thanks
Ron

[jovery]

What where the errors? Did they generate trace files? If so you will be able to establish the time and date from the trace output.

Regards

[vr76413]

thanks jovery...

this is what i see on my alert log.
*******************************************************************
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
ORA-3217 signalled during: alter tablespace temp default storage (pctincrease...
ORA-3217 signalled during: alter tablespace temp default storage(pctincrease ...
****************************************************************


now how do i see if it generated the trace file ?...and where can i find that trace file ?

Thanks
Ron

[jovery]

Do you have a process which is trying to take an online backup of the temp tablespace or is trying to alter the storage parameters both or which are not possible/required with a locally managed temp tablespace?

Regards