datafile offline drop problem
From: Harmony Wong <harmony_wong_at_hotmail.comDUMMY>
Date: 2000/04/29
Message-ID: <8ecnon$269$1_at_news.hk.linkage.net>#1/1
Date: 2000/04/29
Message-ID: <8ecnon$269$1_at_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;
[Quoted] 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
[Quoted] 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