Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: remove a datafile.

Re: remove a datafile.

From: Hermann Schlösser <hs_at_technologist.com>
Date: Wed, 29 Nov 2000 23:48:13 +0100
Message-ID: <90413m$cjj$06$1@news.t-online.com> 






Chris Lee wrote:



> I accidentially created an extra datafile for one of my

> tablespacess. I would like to know if there is any way I

> can remove that datafile.




Hi Chris,



you can export all objects in the tablespace in question
using the export-utilitiy (Documetation in Oracle 
Utilities). 


Then drop old Tablespace, create new tablespace and 
import your data.



good luck


Hermann
Received on Wed Nov 29 2000 - 16:48:13 CST












Original text of this message













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