Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafile offline drop problem

Re: datafile offline drop problem

From: Harmony Wong <harmony_wong_at_hotmail.comDUMMY>
Date: 2000/04/29
Message-ID: <8edrqs$cbr$1@news.hk.linkage.net>#1/1

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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US