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;
to offline 1 datafle.
However, sometimes errors when select recordset from view:
Error in database services:
Any help would be appreciated.
Regards,
ORA-01110: data file 3: '/oracle/u02/oradata/ERB/temp01.dbf' ERB
Harmony