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: ORA-1654 , Oracle asking for very large extent

Re: ORA-1654 , Oracle asking for very large extent

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 31 Jul 2006 23:16:33 +0200
Message-ID: <olssc2pgnb2lhtq4f3lsl4okp8ge5nl29u@4ax.com>


On 31 Jul 2006 13:29:10 -0700, "Zhu Chao" <zhuchao_at_gmail.com> wrote:

>I was wrong about the max-extent, but right on next_extent;
>not much usage to dig that detail, but it is that;
>
>--build tablespace a with blocksize 8k, 101m.
>create table a as select * from dual;
>create table b as select * from dual;
>for i in 1..10 loop execute immediate 'alter table a, b allocate
>extent';
>while true loop execute immediate alter table a allocate extent;
>...then it fails when run out of space;
>
>now I drop table b, there is free space big enough for next_extent a
>need, it is 5177k. next_extent for a is 4m. but it fails.

Actually you are altering the rules, because you don't disclose the properties of the affected tablespace. Who can tell it isn't a DMT or an uniformly managed LMT.
Your little experiment is not to be trusted.

Also there seems to be something wrong with your hands or your eyes, or even both,as you stick to the stupid TOP-POSTING!!!!!

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Jul 31 2006 - 16:16:33 CDT

Original text of this message

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