RE: Auto Extend

From: Gary Weber <gweber_at_cji.com>
Date: Thu, 31 May 2001 12:19:05 -0700
Message-ID: <F001.00316A6C.20010531123057@fatcity.com>

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: rlsmith_at_kmg.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.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

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

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gary Weber
INET: gweber_at_cji.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