RE: Maximum Number of Tablespace on 8.1.7.2

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 06 Aug 2002 15:03:52 -0800
Message-ID: <F001.004ACE42.20020806150352@fatcity.com>

It's per Tablespace (in his post)

-----Original Message-----
Sent: Tuesday, August 06, 2002 6:09 PM
To: Multiple recipients of list ORACLE-L

The maximum number of datafiles for 8i on Windoze is 65534.

Where did you get the 1022 number?

Jared

"James Damiano" <jadam_at_nhes.state.nh.us> Sent by: root_at_fatcity.com
08/06/2002 12:18 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re:Maximum Number of Tablespace on 8.1.7.2

Gilbert,

The maximum number of tablespaces is ~=2 Billion.

The maximum number of datafiles per tablespace is 1022.

See the following link:

        http://www.itsystems.lv/gints/oracle_limits.htm

Jim Damiano

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: James Damiano
  INET: jadam_at_nhes.state.nh.us

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Jared.Still_at_radisys.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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). Received on Tue Aug 06 2002 - 18:03:52 CDT