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

by 8192 is 8k block. Assume your blocksize is 8k, it is trying to allcoate a 64M extent;

So, run this;

select count(*) from dba_free_space where tbalespace_name='L1 or I1?'; and you know why it fails;

reaching max extent will give another different error message; and max-extent sill apply in lmt tablespace.

Brian Peasland wrote:
> > Something seems amiss...There is 7GB of free space in the tablespace.
> > The max extent allocated with AUTOALLOCATE is 8MB.
>
> I should offer a correction to my post...
>
> I queried one of my large databases and found the max extent to be much
> larger than 8MB, as you can see below:
>
> SQL> select max(bytes) as bytes from dba_extents;
>
> BYTES
> ----------------
> 503,365,632
>
> While much larger than the 8MB I originally posted, it should still fit
> quite easily in a tablespace with 7GB of free space.
>
> Cheers,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Mon Jul 31 2006 - 13:17:18 CDT