Failed to drop a tablespace in Oracle 6.0.36

I have a tablespace which consists of 3 data files, totalling 450 MB. I had been having problem accessing data from a table on this tablespace (corrupted segment). We ran a disk check to see if there is any bad spot on which the data files are residing. Everythin checked out OK. I suspected that the Oracle internal structure which manages the tablespaces/tables was corrupted. Therefore, I decided to drop the tablespace, delete the data files at the operating system level, re-create the tablespace, and then re-load the data. (another reason of doing this is to re-populate the database with the latest data available) However, I failed to drop this tablespace.

Here is what I have done:
1) connect to Sql*Plus as user SYSTEM
2) execute the following commands:

   alter tablespace TARGET offline normal;    drop tablespace TARGET including contents; 3) re-boot because my machine was not responding 4) examine the status on tablespace TARGET and find out the tablespace has been brought off-line, but it is not dropped.

questions:

1. Do I have to connect as INTERNAL instead?
2. Do I need to modify my DC_FREE_EXTENTS/ROW_CHCEE_ENQUEUES in init.ora?

Please help. Thanks. Cindy Countryman

ps. Please direct your answers to my E-mail. Received on Mon Apr 25 1994 - 21:20:17 CEST