Having a fast way to drop a 10G bytes tablespace ?

Hi,

Do you know which is a fast way to drop a 10G bytes tablespace in Oracle 7.3.3?

I had tried to execute "drop tablespace ... including content " command to do this, however, the job was terminated after it ran around an hours. The system reports ".....rollback segment ....problem " (I cannot remember the full statement of the error message).

The command is a DDL statement, how come it plays with rollback segment ?

Please help.

Thanks. Received on Wed Oct 13 1999 - 11:50:32 CDT