Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: having multiple datafiles per tablespace vs. one datafile per

RE: having multiple datafiles per tablespace vs. one datafile per

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Mon, 18 Sep 2000 15:21:50 -0400
Message-Id: <10623.117277@fatcity.com>


Is this for 8.1.6? I searched through metalink for this, and couldn't find the reference -- do you remember what you were looking at?

All I found was confirmation that the max. number of datafiles on Solaris for 8.1.6 was 65534. And another cool thing -- the MAXDATAFILES parameter at db creation is no longer the hard limit -- the control file will actually expand to accomodate more files, as long as your db_files parameter allows it.

I love metalink.

Diana

-----Original Message-----
From: Linda Wang [mailto:lwang_at_messagemedia.com] Sent: Monday, September 18, 2000 12:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: having multiple datafiles per tablespace vs. one datafile per

According to the metalink, only 1000 datafiles have been tested by Oracle Co. -Linda

-----Original Message-----
Duncan
Sent: Friday, September 15, 2000 7:28 PM To: Multiple recipients of list ORACLE-L per

I assume you are responding to me?

The documentation I have for Solaris 2.x is the Oracle 8i Administrator's Reference. In the Database Limits section it has the maximum value for MAXDATAFILES as 65534, which is a far cry bigger than 4000. Like I said, the numbers make me nervous, so if you can point me to any other documentation of the limitations I would be most grateful.

Thanks,
Diana

-----Original Message-----
Sent: Friday, September 15, 2000 4:36 PM To: Multiple recipients of list ORACLE-L per

I will not work. See limitation about number of datafiles. As I understand is
going to be over 4000 tablespaces located in separated database files...

--
Author:
  INET: IlicR_at_stentor.ca

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). -- Author: Diana Duncan INET: Diana_at_fileFRENZY.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). -- Author: Linda Wang INET: lwang_at_messagemedia.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
Received on Mon Sep 18 2000 - 14:21:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US