RE: Row Migration/Rowchaining

  • From: "John Hallas" <john.hallas@xxxxxxxxxx>
  • To: <TESTAJ3@xxxxxxxxxxxxxx>, <maheswara.rao@xxxxxxx>
  • 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. 

 

http://jhdba.wordpress.com/

 

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. 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
TESTAJ3@xxxxxxxxxxxxxx
Sent: 11 April 2008 19:54
To: maheswara.rao@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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; 

joe 

---------------------------------------



 


























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
--
//www.freelists.org/webpage/oracle-l






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

Other related posts: