Re: Create table statement, weird behavior...

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"?

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
> >
> >
>
>
Received on Wed May 08 2002 - 15:08:26 CDT