Thanks Dennis I was going to use LMT's, I didn't mention it in my email as I thought it would be irrelevant to the question I was asking.
The first database in question to move is oracle financials 11.5.7 which requires you to move to LMT's Darren -----Original Message----- Sent: Thursday, September 26, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Darren - Let me try to clarify my answer. 1. Yes, 800-meg is not really large with today's disk systems, so that consolidation should be no problem. 2. If you are doing this type of consolidation, I think it would be a good time for you to take as step back for broader perspective. Specifically, it might be a good time for you to take a look at LMTs. Most of us DBAs only perform this type of reorganization every few years, so it is a good idea to incorporate the latest thinking. One of the reasons Oracle is moving us toward LMTs is to reduce the DBA workload, so the Microsoft heads can't keep saying "not only is Oracle more expensive, but it takes a lot more management." Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- Sent: Wednesday, September 25, 2002 7:47 PM To: '[EMAIL PROTECTED]' Darren - My advice would be to read up on Locally Managed Tablespaces (LMT) and uniform extents. This is a new feature that will ease your management work. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, September 25, 2002 6: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:[EMAIL PROTECTED] ------------------------------------------------------------------------ --------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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).