Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maxextents unlimited on LMT ?

Re: Maxextents unlimited on LMT ?

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 10 Jul 2002 14:14:00 -0700
Message-ID: <agi82o02bl8@drn.newsguy.com>


In article <3D2C8F79.6BFD_at_yahoo.com>, Connor says...
>
>Pete Sharman wrote:
>>
>> snip
>> >
>Dunno what version (!) - I've recently grabbed a second disk (120G) for
>the home PC (only cost 90) so I've currently got
>
>8.1.6.3
>8.1.7.3
>9.0.1.2
>9.0.1.3
>9.2
>
>all under Win2K... It was one of them! I'm guessing 8.1.7.3 (since its
>the top-most icon on the desktop!)
>
>As you can see - I put a lot of careful and rigorous thought into this
>test :-)
>
>But - I'll do it again under 9.2 - results below:
>
>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:22.06
>SQL> drop table x.p;
>
>Table dropped.
>
>Elapsed: 00:00:03.04
>SQL>
>
>Interesting - they've souped up the the DROP part...
>
>Cheers
>Connor
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."

Yep, the next thing you'll see is an error message saying "You idiot, don't use 32K UNIFORM SIZE for a tablespace that big! ;)

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Jul 10 2002 - 16:14:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US