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 -> Drop datafile

Drop datafile

From: Bernard Bourdon <bernard.bourdon_at_pi.be>
Date: Sun, 5 Aug 2001 20:35:38 +0200
Message-ID: <9kk3nj$eva$1@news.planetinternet.be> 






I want to delete an empty datafile that I just created by mistake. I use the
command "alter database datafile 'xxx' offline drop". No error, the datafile
is offline but is not dropped. What can I do ? Can I modify some system
tables directly (I would have done that on MS Sql Server in a few seconds) ?




Thanks,


Bernard
Received on Sun Aug 05 2001 - 13:35:38 CDT












Original text of this message













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