Never say never :)
I opted for 4 GB files in a larger database which is living happily on EMC
Sym box. If hardware and software allow for fewer, easier managed large
files...why not? This is scratching the surface of course...
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
-----Original Message-----
Sent: Thursday, May 31, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
By the way ....... For your own sake ..... never use data files that big
!! My personal opinion is multiple files of 500 Megs or less . Or, on a
system that has a file limit, 1 GB files as a Max. Larger than that and
you can have problems with backup software .... long running FTPs if you
duplicate DBs ...etc.
-----Original Message-----
Sent: Thursday, May 31, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
What do you mean by 'the system is not set up'. How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit. Is it documented?
Please explain. Thank you.
-----Original Message-----
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L
If the system is not setup to allow files bigger than 2 GB then the
datafiles WILL NOT EXTEND and you will get an oracle error.
-----Original Message-----
Sent: Thursday, May 31, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L
I have taken over an Oracle database that is setup with autoextend on the
tablespaces. Can anyone tell me what happens when the datafiles extend
beyond 2G on Unix?
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Gary Weber
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
