Re: ora-1652 Help Please

The status of my temp tablespace is permanent. What would that do if I changed it to temporary?

In article <379EA68C.59F49464_at_at.siemens.de>,   Markus Korn <markus.korn_at_at.siemens.de> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 07:42:33 CDT