Number of extents

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$