RE: Row Migration/Rowchaining
Date: Tue, 15 Apr 2008 09:56:03 +0100
You need to analyze tables and list chained rows. @utlchain
I believe that oracle does not discriminate between a chained and migrated row even though they have different causes
In fact Metalink Note 102989.1 indicates that the resolution is the same for both types identify the rows, copy the chained rows out to anew table, delete them from the original table and then move them back again.
PS, not worth a separate post but I wrote an article about log shipping (dataguard, streams etc) on my blog site and discovered it had been linked to a Forklift Truck site today. Obviously shipping was the key word.
PPS, Joe do you still have your RMAN scripts online. They used to be a good resource. Probably a bit out of date now though.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: 11 April 2008 19:54
Subject: Re: Row Migration/Rowchaining
This will show you the table for chained rows, not sure if it covers migrated or not, anyone else?
select owner, table_name, chain_cnt from dba_tables where chain_cnt > 0;
Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.
UBS Financial Services Inc.
UBS International Inc.
UBS Financial Services Incorporated of Puerto Rico
The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW
http://www.freelists.org/webpage/oracle-l Received on Tue Apr 15 2008 - 03:56:03 CDT