Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Maxextents unlimited on LMT ?
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