From MohanR@STARS-SMI.com Wed, 15 Aug 2001 09:25:07 -0700 From: "Mohan, Ross" Date: Wed, 15 Aug 2001 09:25:07 -0700 Subject: WARNING Dangerous Upgrade path! Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ok, settle down. I just migrated from 80520 to 81600 on Siemens and the migrate consistently choked on the AQ$ update stuff. Something to do with objects...raw data types.... Oracle provided a patch which did not work. We finally had to migrate holding the database at compatible=8.0.5.2.0, but....we think the AQ$ stuff may be held back at that level....not sure, and oracle sure as hell ain't telling. anyway, heads up. -----Original Message----- Sent: Wednesday, August 15, 2001 10:01 AM To: Multiple recipients of list ORACLE-L truncate doesn't change the hwm unless you drop storage also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage. Oracle has to update the UET$ and FET$ tables for each extent you release. >From: Hallas John >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: Speed up Truncate tables >Date: Wed, 15 Aug 2001 01:25:59 -0800 > >Chuan, > >Are you sure you were using the TRUNCATE TABLE command rather than DELETE >It sounds as if you are running a delete, especially if the HWM was not >shrunk > >John >-----Original Message----- >Sent: 15 August 01 09:10 >To: Multiple recipients of list ORACLE-L > > >Hi All, > > Is there any way to speed up the truncating a big table with 12 >million >rows? > >Basically, I implemented truncating that big table on Production, but it >affected the performance much, so I had to stop it in the middle of way. >All >the rows were truncated but the HWM was not shrunk at all. I want to do it >again to get the space back. Is there any way to speed up this process? > >Platform: Oracle EE8.0.6 and Solaris 2.7 > >Thanks a lot in advance. > >Chuan > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Chuan Zhang > INET: chuan@asiaonline.net > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). > > > >********************************************************************** >This email and any attachments may be confidential and the subject of >legal professional privilege. Any disclosure, use, storage or copying >of this email without the consent of the sender is strictly prohibited. >Please notify the sender immediately if you are not the intended >recipient and then delete the email from your inbox and do not >disclose the contents to another person, use, copy or store the >information in any medium. >********************************************************************** _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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: Mohan, Ross INET: MohanR@STARS-SMI.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).