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_at_fatcity.com [mailto:root_at_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_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

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