Re: Maxextents unlimited on LMT ?

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:agfi8v02fvu_at_drn.newsguy.com...
> In article <3D2B34C3.1E50_at_yahoo.com>, Connor says...
> Hmm, not sure what you ran this on (maybe you've turned off the FAST=TRUE
> parameter!). Here's what I get on my PC with 9.2:

I get similar results to Connor on 9.01.

SQL> create tablespace dummy
  2 datafile 'c:\temp\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:01:04.05
SQL> drop table x.p;

Table dropped.

Elapsed: 00:00:03.05
SQL> alter user x quota unlimited on dummy;

User altered.

Elapsed: 00:00:00.00
SQL> create table x.p ( x number ) tablespace dummy   2 storage ( initial 99m next 99m minextents 10 );

Table created.

Elapsed: 00:00:25.02
SQL> drop table x.p;

Table dropped.

Elapsed: 00:00:01.00
SQL> Received on Wed Jul 10 2002 - 03:12:02 CDT