RE: Maximum Number of Tablespace on 8.1.7.2

From: Ishrat Jehan <ijehan_at_dgsystems.com>
Date: Wed, 07 Aug 2002 14:16:31 -0800
Message-ID: <F001.004AE287.20020807141631@fatcity.com>

>From what I have read there is no official limitations on the max number of
tablespaces. But it cannot be higher than 65534 because that is max number of datafiles per database. As a datafile can belong only to one tablespace, there can only be up to 65534 tablespaces.

        The max number of datafiles per tablespace depends on OS and most of them, it is 1022.
...Ishrat         

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

that's datafiles PER tablespace, not total for the database... and I believe that is in the docs

• Jared.Still_at_radisys.com wrote:
  > 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).
  

  ---

Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: Ishrat Jehan
  INET: ijehan_at_dgsystems.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 Wed Aug 07 2002 - 17:16:31 CDT