Re: ora-1652 Help Please

Hi,

what is the status of your temporary tablespace? Is it temporary? if not try: alter tablespace temp temporary;

hooch432_at_my-deja.com wrote:
>
> 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 Wed Jul 28 1999 - 01:43:24 CDT