Drop Tablespace Problem

From: Ian Sparkes <sparkes_at_sprintmail.com>
Date: 1997/05/30
Message-ID: <01bc6d4f$9decb130$11f0dfdf@sprintmail>#1/1

Has anybody seen a problem where after a drop tablespace command, the tablespace still appears in a "select tablespace_name from dba_tablespaces;". I'm trying to see if it is possible to determine what the original cause might have been (with a view to preventing a reoccurrence until upgrade is possible), apparently this has been happening for over a year.

Database version is 7.0.16 running on HPUX 9.

The site now has further corruption problems in their Oracle catalog and I am working with them to help remedy the situation. The only fix is an exp/imp but this is complicated but 24x7 operation with a 100GB database so the planning is taking a while. Received on Fri May 30 1997 - 00:00:00 CDT