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 delete datafile from tablespace using SQL?

Re: How to delete datafile from tablespace using SQL?

From: Michael Ju. Tokarev <mjt_at_tls.msk.ru>
Date: Thu, 30 Dec 1999 17:46:56 +0300
Message-ID: <386B7060.7B22A3C2@tls.msk.ru> 





It is impossible in all current versions of oracle.
If you really need this, you can recreate teblespace
(i.e. export all it's data, drop it, create it and import data back).
If it is a system tablespace, you should recreate a database.
But I think you can allow this datafile to be exist...
Use "rename datafile" to reflect a move operation.
Received on Thu Dec 30 1999 - 08:46:56 CST












Original text of this message













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