Re: datafile offline drop problem

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 Sat Apr 29 2000 - 00:00:00 CEST