Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Max initial size on WinNT server

RE: Max initial size on WinNT server

From: Ronen Levit <RonenL_at_talmai.com>
Date: Tue, 15 Aug 2000 19:36:21 +0200
Message-Id: <10590.114623@fatcity.com>


Here is the ddl -

PROMPT Creating Table 'XXX'
CREATE TABLE XXX
 (...
 ,CONSTRAINT XXX_PK PRIMARY KEY
  (...)
 )
 ORGANIZATION INDEX
 STORAGE
 (
 INITIAL 4531M
 NEXT 453M
 PCTINCREASE 0
 MINEXTENTS 1
 MAXEXTENTS 10
 )
 COMPRESS 1
 INCLUDING X1 overflow
 TABLESPACE X
/

-----Original Message-----
From: Lyall Barbour [mailto:lbarbour_at_stanford.edu] Sent: Tuesday, August 15, 2000 5:55 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Max initial size on WinNT server

Can you show us your statement? Are you actually typing in STORAGE (INITIAL 5G NEXT blah PCTINCREASE blah) ?

I'm not sure about the maximum size, I know you can't have an extent spanning datafiles and I always thought datafiles really shouldn't be larger then 2 gig. I know I've made 3 and 4 gig datafiles.... anyway, ummmmm, ya, not sure about the max initial. But you definitely can't have extents spanning datafiles, and you can't say INITIAL 2G or 3G, you must put INITIAL 5000M. Or if you want to be exact, calculate 5 gig into megabytes.

HTH
Lyall Barbour
At 12:38 AM 8/15/00 -0800, you wrote:
>Does any of you can reference me to the maximum initial size of segment on
>WinNT server?
>
>I'm trying to create a table with 5GB initial size, and I get
>ORA-2218.
>
>Thnx,
>
>Ronen Levit
>Database group manager
>Talmai
>Tel: +972 8 9460606 #212
>Fax: +972 8 9460705
>Cell: +972 52 448699
>
>--
>Author: Ronen Levit
> INET: RonenL_at_talmai.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Author: Lyall Barbour
  INET: lbarbour_at_stanford.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Tue Aug 15 2000 - 12:36:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US