Re: Create table statement, weird behavior...

From: Jim <jimnmitsy_no_spam_for_me_please_at_cableone.net>
Date: Wed, 8 May 2002 14:47:08 -0500
Message-ID: <udj0684v9moeb0@corp.supernews.com>

K is understood.. I've tried K and 50M, same thing, 81 extents...

Thanks anyway...

"Frank" <fbortel_at_home.nl> wrote in message news:3CD98D93.7080203_at_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 - 14:47:08 CDT