Oracle-L: Re:Maximum Number of Tablespace on 8.1.7.2

From: <Jared.Still_at_radisys.com>
Date: Tue, 06 Aug 2002 14:18:25 -0800
Message-ID: <F001.004ACC7F.20020806141825@fatcity.com>

Never mind, I misread your email. :)

Jared

Forwarded by Jared Still/Radisys_Corporation/US on 08/06/2002 02:15 PM -----

Jared Still
08/06/2002 01:58 PM

        To:     ORACLE-L_at_fatcity.com
        cc:     jadam_at_nhes.state.nh.us
        Subject:        Re:Maximum Number of Tablespace on 8.1.7.2

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