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: pier <maxpier702001_at_yahoo.it>
Date: 19 Aug 2004 03:02:31 -0700
Message-ID: <ca39bcb7.0408190202.a4050c4@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.




alter tablespace name tbs datafile 'datafile name' offline drop;
Received on Thu Aug 19 2004 - 05:02:31 CDT












Original text of this message













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