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).
Received on Tue Aug 06 2002 - 20:38:20 CDT
