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: 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).
