Q: How to re-insert chained rows?

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Tue, 09 Aug 2005 16:29:20 GMT
Message-ID: <1emhf19l12jfu04l4cs6008f8v6bgk3vrq@4ax.com>

I had an error and found this solution on metalink:

---

This error can indicate that the second row piece of a chained row is held in a block that can not accept any more transactions due to current activity (MAXTRANS may have been reached.)

Check for chained/migrated rows using :

ANALYZE TABLE <table_name> LIST CHAINED ROW INTO Chained_Rows;

If found, consider increasing PCTFREE to avoid additional chaining and then re-insert the chained rows highlighted above.

---

I did

@$ORACLE_HOME/rdbms/admin/utlchn1.sql

then

SQL> ANALYZE TABLE "RFBLG" LIST CHAINED ROWS INTO Chained_Rows;

Then

set linesize 120
col owner_name format a10
col table_name format a15
col cluster_name format a7
col partition_name format a9
col subpartition_name format a12
col head_rowid format a20

SELECT * FROM chained_rows;

And got:

OWNER_NAME TABLE_NAME CLUSTER PARTITION SUBPARTITION HEAD_ROWID A
NALYZE_T
---------- ----------- ------- --------- ------------

• -

  ---

  SAPR3 RFBLG N/A AAAHFxAALAAAMD7AAD 0 9-AUG-05

5061 rows selected.

So.... How do I:
"...re-insert the chained rows highlighted above."

---

Come race with us!
http://www.mgpmrc.org Received on Tue Aug 09 2005 - 11:29:20 CDT