Re: Create table statement, weird behavior...

In article <udj1e2mpiea91a_at_corp.supernews.com>, "Jim" says...
>
>Johathan,
>
> Great site, very helpful link, thankyou...
>
> This is 9i, your link suggest the preference of LMT's. Should I just
>leave well enough alone? I have 1 table with over 120 extents. Would I do
>better to make it "Dictionary Managed"?
>

having more then 1 extent is fine, good, not a problem, nothing to lose sleep over, in many cases preferable.

Hundreds of extents is great.

LMTs are the default tablespace type in 9i. Stick with them.

>Thanks..
>
>Jim
>
>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:1020887349.24761.0.nnrp-08.9e984b29_at_news.demon.co.uk...
>>
>> Is tablespace DATA a locally managed tablespace ?
>> If so see
>> http://www.jlcomp.demon.co.uk/ch_08.html
>>
>>
>> --
>> Jonathan Lewis
>> http://www.jlcomp.demon.co.uk
>>
>> Author of:
>> Practical Oracle 8i: Building Efficient Databases
>>
>> Next Seminar - Australia - July/August
>> http://www.jlcomp.demon.co.uk/seminar.html
>>
>> Host to The Co-Operative Oracle Users' FAQ
>> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>>
>>
>>
>> Jim wrote in message ...
>> >Hi,
>> >
>> >Running on NT 4.0 SP6a, Oracle DB 9.0.1.3.1, Compaq Server 2 CPU's, 2
>gigs
>> >of memory, blah, blah, blah...
>> >
>> >CREATE TABLE TEMP (
>> > TEMP CHAR(1)
>> > )
>> > TABLESPACE DATA PCTFREE 10
>> > STORAGE(INITIAL 300M NEXT 10240 PCTINCREASE 50 )
>> >
>> >This statement produces a 300M Table with 81 extents? From what I
>> >understand this statement is supposed to create 1 extent 300M, not 81
>> >extents. Is there any reason anybody can think of that my Database would
>> be
>> >behaving this way? Metalink seems stumped. The database is running
>fine,
>> I
>> >don't have any invalid objects. ??
>> >
>> >Thanks in Advance..
>> >
>> >Jim
>> >
>> >
>>
>>
>
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp