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: "drop tablespace xyz including contents" shouldn't be necessary

Re: "drop tablespace xyz including contents" shouldn't be necessary

From: Carlos Batista <cbatista_at_caravela.di.fc.ul.pt>
Date: Fri, 29 May 1998 21:33:54 +0100
Message-ID: <356F1BB1.566DD519@caravela.di.fc.ul.pt>


johnvue_at_gte.net wrote:

> Anyone know why I have to DROP TABLESPACE XYZ INCLUDING CONTENTS when
> DBA_SEGMENTS reports no objects in that tablespace?

   Just do a query on dba_objects and check if any are present on the tablespace.... Received on Fri May 29 1998 - 15:33:54 CDT

Original text of this message

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