ora-1652 Help Please

I have someone who is running a very large report (approx. 26hrs) and about 5 hours into the report around 14:00 they received the error ORA- 01089: immediate shutdown in progress. I know you get this when the database is not available. However in the alert log about the same time I had the error ORA-1652: UNABLE TO EXTEND TEMP SEGMENT BY 2560 IN TABLESPACE TEMP. I don't see anything about a shutdown until the next morning about 7am. Why wouldn't the user see the ORA-1652 instead of seeing the ORA-01089: SHUTDOWN error when the database was not unavailable at the this time?

I have been told to solve the ORA-1652 error is to add an additional datafile to the TEMP tablespace is this correct? I seem to have some fragmentation on the TEMP tablespace (TOAD) : Total Blocks=140800, Empty Blocks=140799, # pieces=55, Large=2560 (same # that is in the error), Avg.=2560, Sm=2559.
TEMP tablespace size: 550MB, Inital Ext.=10485760, Next=10485760, Max Ext=121, and %increase=0.

Will adding a datafile solve my problem? Oracle v.7334 OpenVMS 7.1 (DBA is on vacation!)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 27 1999 - 15:32:33 CDT