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-----
From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
Sent: Thursday, 24 July 2003 11:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Datafile sizing
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" <Rich.Jesse_at_qtiworld.com> 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
> rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
>
>
> > -----Original Message-----
> > From: Biddell, Ian [mailto:ian.biddell_at_hp.com]
> > 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: Rich.Jesse_at_qtiworld.com
>
> 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: 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).
>
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: wisernet100_at_yahoo.com
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: 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
Received on Thu Jul 24 2003 - 16:30:18 CDT
