Tablespace with no datafile

From: Erma Fernando <FernanEr_at_oeb.gov.on.ca>
Date: Wed, 02 Aug 2000 08:47:16 -0400
Message-Id: <10577.113582@fatcity.com>

I tried to install webb on Oracle 8.1.6 database (solaris 2.7). I chose a tablespace from the list of tablespaces during the installation. I chose a tablespace - but now I notice there is no datafile associoated with it.

I am trying to get rid of the tablespace. dba_tablespaces shows the existence of the tablespace. dba_data_files does not show the tablespace or the datafile associated with it.

I tried to drop the tablespace or even take it offline.

I get ORA 600 with arguments [2897] [11] [2048] [ ] [ ] [ ] [ ] .

How can I get rid of this tablespace.

I have contacted Oracle support too. Received on Wed Aug 02 2000 - 07:47:16 CDT