Answer 1:
I tried again, first taking the datafile offline and dropping it,
then taking the tablespace offline.  It didn't help.
I have a call in to Oracle Support.  This is very weird.

Chris O'Connor
 

Answer 2:

The "DROP TABLESPACE" command will drop each table in the tablespace and
the drop table will use rollback segments (and by extension, the redo
logs).  The command can be sped up by truncating all of the tables in
the tablespace prior to dropping the tablespace.

I.E.
SPOOL drop_tables.sql
SELECT 'TRUNCATE TABLE ' || owner || '.' || table_name || ' ;'
FROM dba_tables WHERE tablespace_name = 'target_tablespace'
SPOOL OFF
@drop_tables.sql

The above command will create a list truncate table commands for the
tables in the targeted tablespace, that list is then executed.

HTH
    James

  In article <[email protected]>,
  [email protected] wrote:

Question:

>
>
> I am running 8.1.5 on Solaris and using raw volumes for some
> of the tablespaces.
>
> I tried "drop tablespace raw_tabsp including contents" and
> was surprised to see the command still running  after 30 minutes.
> It is almost 2 GB in size.
> I didn't think that this operation would use RBSes.
> What could be taking so much time?
>
> Chris O'Connor