Re: Tablespace dropped, How to remove from view?
From: Salahuddin Faruqui <BTJV84A_at_prodigy.com>
Date: 1996/07/11
Message-ID: <4s3led$1oa8_at_useneta1.news.prodigy.com>#1/1
Date: 1996/07/11
Message-ID: <4s3led$1oa8_at_useneta1.news.prodigy.com>#1/1
cfischer_at_ancillary.utmrad1.utmb.edu (Cathy Fischer) wrote:
>
>I have dropped a tablespace and shutdown and re-started the database but
when
>I query the DBA_TABLESPACES view that tablespace still shows up. It has
a
>status of INVALID. Why is it there? Is there anyway to get rid of it?
>
It could be that an active segment (e.g rollback segment ) was present
when the tbsp was dropped. In such an event you would have to clear the
active (now invalid ) segment to clear the tablespace.
Regards
-
Obaid A. Faruqi
Received on Thu Jul 11 1996 - 00:00:00 CEST