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: Problem dropping tablespace

Re: Problem dropping tablespace

From: Uldis Pavuls <U.Pavuls_at_konts.lv>
Date: Wed, 11 Aug 1999 12:11:46 +0300
Message-ID: <7orepe$kfh@news.latnet.lv> 





See DROP TABLESPACE .... INCLUDING CONTENTS CASCADE CONSTRAINTS. You might
need start instance with NOMOUNT option, though. I have done it once, but i
do not remember exact details. Nevertheless it is possible.
HTH ,



Uldis



Vijay Mayadas wrote in message <37b0a191_at_news1.us.ibm.net>...


>I've lost the datafile for one of my tablespaces and wish to drop the


>tablespace and recreate it.


>




Received on Wed Aug 11 1999 - 04:11:46 CDT












Original text of this message













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