RE: ** chained rows fixing

From: <JayMiller_at_TDWaterhouse.com>
Date: Fri, 23 Sep 2005 18:06:55 -0400
Message-ID: <5B257A26B4845C469B87871B6CEFE5070331AE12@usnjc04wmx003.tdwaterhouse.com>

While this doesn't help you now I highly recommend a company standard of having a package variable that's checked at the beginning of each trigger as you mention. It's made our lives *so* much easier.

Thanks,

Jay Miller

Sr. Oracle DBA

x68355

-----Original Message-----

From: A Joshi [mailto:ajoshi977_at_yahoo.com] Sent: Friday, September 23, 2005 1:50 PM To: oracle-l_at_freelists.org
Subject: ** chained rows fixing

Hi,

I need to get rid of chained rows for some tables. Re-insert (delete and insert) the rows. Some of the tables have triggers so it is difficult. IS there a way to execute the delete and insert without the triggers firing. Meaning is there a way to make sure trigger does not fire for a session. One way would be to declare a package variable and check it in the beginning of a trigger but that would need change to all triggers.

To disable triggers would require that rest of application be shut down.

I plan to increase the pctfree to prevent chained rows in future. Is there any thing else I need to do. I assume a simple delete and insert will eliminate chained row. Do I need anything else. Can some provide a generic script for this. I have all the chained row in table chained_rows. Any other guidelines. Thanks. Help is appreciated.

Yahoo! for Good
Click here to donate <http://store.yahoo.com/redcross-donate3/> to the Hurricane Katrina relief effort.

This message is confidential and sent by TD Waterhouse solely for use by the intended recipient. If you are not the intended recipient, you are hereby notified that any use, distribution or copying of this communication is strictly prohibited. This should not be deemed as an offer or solicitation, to buy or sell any product. Any 3rd party information contained herein was prepared by sources deemed reliable, but is not guaranteed. TD Waterhouse does not accept electronic instructions that would require an original signature. Information received by or sent from TD Waterhouse is stored, subject to review, and may be produced to regulatory authorities or others with a legal right to such.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 23 2005 - 17:12:07 CDT