Re: Create table statement, weird behavior...

From: Frank <fbortel_at_home.nl>
Date: Wed, 08 May 2002 22:41:55 +0200
Message-ID: <3CD98D93.7080203@home.nl>

Jim wrote:

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

Typo: next 10240? Must be 10240K?
Retry with that Received on Wed May 08 2002 - 15:41:55 CDT