RE: Another datafile sizing question

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Wed, 25 Sep 2002 16:48:21 -0800
Message-ID: <F001.004D97B0.20020925164821@fatcity.com>

Is there a reason you can't just resize the existing file?

-----Original Message-----
Sent: Wednesday, September 25, 2002 7:43 PM To: Multiple recipients of list ORACLE-L

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

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

Author: Johnston, Tim
  INET: TJohnston_at_quallaby.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). Received on Wed Sep 25 2002 - 19:48:21 CDT