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 -> Re: How to drop a datafile from tablespace?

Re: How to drop a datafile from tablespace?

From: <sybrandb_at_yahoo.com>
Date: 19 Aug 2004 04:09:01 -0700
Message-ID: <a1d154f4.0408190309.5d2ab5e6@posting.google.com> 





cnwy_at_263.net (yoke wang) wrote in message news:<42c18ceb.0408182154.5cf02d58_at_posting.google.com>...


> I have added datafiles to a tablespace by mistake.Who can tell me how to drop them?

> 

> Thanks.

> 

> Yoke.




You can't. Resize them to 0, and learn to live with it.
BTW A simple search in the manual would have learned you it is not
possible, because the syntax is lacking. In Oracle there no
undocumented statements.



Sybrand Bakker


Senior Oracle DBA
Received on Thu Aug 19 2004 - 06:09:01 CDT












Original text of this message













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