I tried it. I got the message "error creating the file, file exists". Tablespace was not created (as expected). However the FILE itself also was not created, as if Oracle cleaned up after itself.
--- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > 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). > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
