Re: datafile offline drop problem

Yes, a small concern. Any program attempting to make a temporary object in that tablespace will fail during the short time it doesn't exist. Also, check now to make sure there are no permanent objects accidentally created there and check just before running that there are no temporary objects. This is not a middle of the day task.

Al

Harmony Wong wrote:
>
> Thx for suggestion. Is there any concern for me to drop the TEMP tablespace,
> which is the "temp tablespace" for all the database process?
>
> Harmony
>
> Big Al <db-guru_at_att.net> wrote in message news:390A1344.C3336220_at_att.net...
> > The easiest way to do this is verify that the TEMP tablespace is empty,
> > drop it completely and recreate with one datafile. I just did that five
> > minutes ago on one of my systems. It's also a good time to put in the
> > default storage values you want.
> >
> > Al
> >
> > Harmony Wong wrote:
> > >
> > > Hi all,
> > >
> > > Our Oracle TEMP tablespace consist of 2 data files:
> > > /oracle/u02/oradata/ERB/temp01.dbf
> > > and
> > > /oracle/u03/oradata/ERB/temp02.dbf
> > >
> > > I would like to keep only 1 datafile for temp table space, so I use the
> > > command:
> > > ALTER DATABASE DATAFILE '/oracle/u02/oradata/ERB/temp01.dbf' OFFLINE
 drop;
> > >
> > > to offline 1 datafle.
> > >
> > > However, sometimes errors when select recordset from view:
> > > Error in database services:
> > > [SERVERERROR] Error from Server: ORA-00376: file 3 cannot be read at
 this
> > > time
> > > ORA-01110: data file 3: '/oracle/u02/oradata/ERB/temp01.dbf' ERB
> > >
> > > Any help would be appreciated.
> > >
> > > Regards,
> > > Harmony
Received on Mon May 01 2000 - 00:00:00 CEST