RE: Maximum Number of Tablespace on 8.1.7.2

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 06 Aug 2002 18:18:29 -0800
Message-ID: <F001.004AD1E7.20020806181829@fatcity.com>

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: mardi, 6. août 2002 18:38
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Maximum Number of Tablespace on 8.1.7.2
>
>
> 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

I think the number might be 1023 (or even more?) See below the tablespace with 1023 datafiles.

SQL> select * from v$version ;

BANNER

---

Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production
CORE Version 4.0.6.0.0 - Production
TNS for Solaris: Version 8.0.6.0.0 - Production NLSRTL Version 3.3.3.0.0 - Production

SQL> select tablespace_name, count (*) from dba_data_files   2 group by tablespace_name
  3 having count (*) > 1022 ;

TABLESPACE_NAME                 COUNT(*)
------------------------------ ---------
MANY_DATA_FILES                     1023

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.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 - 21:18:29 CDT