Create table statement, weird behavior...

From: Jim <jimnmitsy_no_spam_for_me_please_at_cableone.net>
Date: Wed, 8 May 2002 14:23:11 -0500
Message-ID: <udiupais35ifb4@corp.supernews.com>

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 - 14:23:11 CDT