datafile offline drop problem

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

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