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 -> dropping data file

dropping data file

From: <daud11_at_hotmail.com>
Date: Fri, 20 Nov 1998 08:20:11 GMT
Message-ID: <7338ni$29q$1@nnrp1.dejanews.com> 





Hi



If I have a tablespace with 2 or more datafiles, can I drop one of them?
I have tried dropping a data file using:
alter database datafile <name> offline drop
but the data file did not get dropped. My database is in archive log mode.
I hope someone can explain this to me.



regards


Daud11



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Fri Nov 20 1998 - 02:20:11 CST












Original text of this message













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