Re: Create table statement, weird behavior...

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

>

>