Sorry I was still setting it all up, the datafiles will be numbered 1 thru 5 :-) I was more concerned if I should add the bitmap header overhead to each datafile or just the first one.
-----Original Message----- Sent: Thursday, 24 July 2003 11:49 PM To: Multiple recipients of list ORACLE-L You'll want to modify your statement first to have different file names for each datafile. Just pointing it out in case the obvious was overlooked... BTW, anyone know what that statement would do? Would it error out? Gotta get another playground for testing... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Biddell, Ian [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 24, 2003 12:34 AM > To: Multiple recipients of list ORACLE-L > Subject: Datafile sizing > > > Hi All, > > I have seen previous discussions on datafile sizing and adding 64k to > the size for the bitmap header. Also other people saying that they > just go for 2001MB when they want a 2000mb datafile. > My question is does each datafile require this within the > tablespace or > is it just one per tablespace to facilitate LMT ? > > So if I have this statement > CREATE TABLESPACE csis_l_tables LOGGING > DATAFILE 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M, > 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M, > 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M, > 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M, > 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 4000M > > extent management local uniform size 64m SEGMENT SPACE MANAGEMENT > AUTO; > > Do I add 1mb to each datafile or just the first? > > Thanks > Ian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Biddell, Ian INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
