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 -> Drop tablespaces with missing datafiles

Drop tablespaces with missing datafiles

From: Sam Jordan <sjo_at_spin.ch>
Date: Tue, 27 Jul 1999 12:44:39 +0000
Message-ID: <379DA9B7.BB3FD38@spin.ch> 





Hi



I would like to drop a tablespace, which doesn't have any content.
By some mistake the datafiles are gone. Now Oracle refuses to
drop the tablespace, because the datafiles aren't present, and I
can't rebuild the tablespace because it's still present. Any ideas
how to solve that?



bye


-- 


Sam Jordan
Received on Tue Jul 27 1999 - 07:44:39 CDT












Original text of this message













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