Message-Id: <10623.117314@fatcity.com> From: Rajesh Dayal Date: Tue, 19 Sep 2000 10:51:17 +0400 Subject: RE: having multiple datafiles per tablespace vs. one datafile per Just for your reference .... This feature of automatic expansion of Control files were there in Oracle 8 also...... -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Diana Duncan Sent: Tuesday, September 19, 2000 12:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: having multiple datafiles per tablespace vs. one datafile per 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----- Sent: Monday, September 18, 2000 12:36 PM To: Multiple recipients of list ORACLE-L 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@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@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@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@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@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@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@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@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