RE: Max initial size on WinNT server

The maximum initial size can't exceed 2gb for any platform on 8i. I ran into this on Solaris as well.

Richard Ji

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Lyall Barbour
Sent: Tuesday, August 15, 2000 11:55 AM
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
also send the HELP command for other information (like subscribing).