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: Deleting datafile from tablespace

Re: Deleting datafile from tablespace

From: Sang Ryung Lee <srlee_at_shinsegi.com>
Date: Thu, 11 Feb 1999 11:58:25 +0900
Message-ID: <36C24751.FE8C4468@shinsegi.com> 





Hi,



There is no way to drop  one of  the datafiles composed of a tablespace.
You have to drop  the temp tablespace and then recreate tablespace.



Though you renamed datafile at OS level, Database still had the old information.
You have to 'alter tablespace rename datafile old to new'



Bye.



Sangryung Lee.



Received on Wed Feb 10 1999 - 20:58:25 CST












Original text of this message













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