RE: Datafile sizing

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?
Received on Thu Jul 24 2003 - 08:19:28 CDT