Drop a data file from a tablespace

From: <yren_at_epsilon.com>
Date: Tue, 05 May 1998 15:19:21 -0600
Message-ID: <6ins89$ddq$1@nnrp1.dejanews.com>

I am running an Oracle 7.3.3 database in NON-ARCHICELOG mode. Now I am trying to drop a data file from a tablespace. I used command "alter database datafile file_name offline drop". The command ran fine, no error message, but when I check system view v$datafile or dba_data_files. The data file was still there. Has anybody done this before? Thanks.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 05 1998 - 16:19:21 CDT