See the accompanying note about extents in 8i before you read the following improvements that are in 9i.
SQL> create tablespace dummy 2 datafile 'e:\orasw\db1\dummy.dbf' size 2001m 3 extent management local uniform size 32k; Tablespace created. SQL> create user x identified by x; User created. SQL> alter user x quota 1000m on dummy; User altered. SQL> set timing on SQL> create table x.p ( x number ) tablespace dummy 2 storage ( initial 99m next 99m minextents 10 ); Table created. Elapsed: 00:02:13.04 SQL> drop table x.p; Table dropped. Elapsed: 00:00:03.02 SQL> spool off
You can see that the 'drop' component has been improved in 9i, being due to a single update to TSQ$