The 4GB problem on NT was ONLY where it would autoextend over a 4gb boundary (eg 4,8,12,16...). You can manually size the datafile whatever size you wish - ie you can cross the boundary manually.
However, one place I recently contracted at were determined to cold backup their 120GB data warehouse system and it was decided to zip the datafiles as part of the backup process. Zip only handles files up to 4GB in size so they standardised on 4000MB datafiles (zipped down they reduced to 80mb - yep huge allocation, little data - it takes all sorts!) - guess who had to rebuild the data warehouse to these specs! ;-( So, on deciding your datafile size, be aware of various issues - mostly regarding the management of these files. I would agree with my previous client that 4gb (or near) is probably the biggest I'd go on windows systems unless there's a *specific* and good reason to go higher. Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -----Original Message----- Sent: 06 September 2002 00:10 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH ---------------------------------------------------------------------- There used to be a bug that caused problems with files on NT 4g or more in size. I've standardsized on 3999 meg as a result of this. ---------------------------------------------------------------------------- ------ Tony Johnson Email : [EMAIL PROTECTED] Manager Database Administration Voice : ( 480 ) 682 - 0849 Trimble Navigation Cell : ( 602 ) 363 - 7328 7408 W. Detroit Street #100 Fax : ( 480 ) 961 - 8801 Chandler, AZ 85226 ---------------------------------------------------------------------------- ------ Murphy's Data Constant:Data will be damaged in direct proportion to its value -----Original Message----- Sent: Thursday, September 05, 2002 2:29 PM To: Multiple recipients of list ORACLE-L What is an ideal datafile size for a large database 10G or greater Oracle 8.1.6 We have been using slightly under 2G and looking for an ideal size and possible reasons to use such a size Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Tony Johnson 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis 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).
