Another datafile sizing question

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Wed, 25 Sep 2002 15:43:20 -0800
Message-ID: <F001.004D9717.20020925154320@fatcity.com>

I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application
certifications.

I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to
create a 800mb datafile and move all the data into it,

The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should
be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile.

Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ?

Thanks

Darren

Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

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). Received on Wed Sep 25 2002 - 18:43:20 CDT