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

On 31 Jul 2006 12:30:34 -0700, "Zhu Chao" <zhuchao_at_gmail.com> wrote:

>Thank you. Seems I was wrong about the max-extent nolonger applies for
>lmt tablespace. Is this true for 9i as well? I don't have access ot
>unix now so can't test.
>

max extents never applied to lmt's.
>Can you do a :
>select bytes, count(*) from dba_extents where segment_name='YOUR BIG
>SEG' GROUP BY BYTES,
>
>See at which stage, it start to use 512M? The last time I did some test
>and I was unable to get to a larger size than 64M, with something like
>500gb space; --data could be differnet, it was 3 years ago.
>
>Also, I believe for next_extent, oracle won't break it up. If there is
>no free extent >= next_extent, oracle fails. if you can test to prove I
>was wrong, I appreciate it. Can't test now.

You definitely describe DMT policies
>
>Thanks
>

Thanks for top-posting and including everything. No other posters have to do the cut-and-paste operations that were too much asked from you.

--
Sybrand Bakker, Senior Oracle DBA