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
Received on Thu Jul 24 2003 - 08:33:30 CDT
