Alert log doesn't have timestamp

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

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

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

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