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: ask one question!

Re: ask one question!

From: Dominic Baines <rdab100_at_hermes.cam.ac.uk>
Date: Fri, 10 Jul 1998 08:44:16 +0100
Message-ID: <35A5C650.67E46CD9@hermes.cam.ac.uk> 





Why not export the tablespace, drop it, recreate it with the appropriate
datafiles and then import ?



Dominic Baines



sor wrote:



> Hi:


>     how to drop one of datafiles belonging to the same tablespace?


> if enter the following command, it would be fail.


>     "alter database datafile filename offline drop;"


> help! ....


> --


> E-Mail : ymy0_at_www.dab.com.tw





Received on Fri Jul 10 1998 - 02:44:16 CDT












Original text of this message













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