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: Big Al <db-guru_at_att.net>
Date: 2000/04/28
Message-ID: <390A1344.C3336220@att.net>#1/1

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 Fri Apr 28 2000 - 00:00:00 CDT

Original text of this message

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