RE: CHAINED ROWS

2002-01-09 Thread SARKAR, Samir
Title: RE: CHAINED ROWS Thanks Jacques...forgot about the Index-organized tables. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115

RE: CHAINED ROWS

2002-01-09 Thread Mike Killough
recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: CHAINED ROWS Date: Wed, 09 Jan 2002 01:56:54 -0800 Thanks Jacques...forgot about the Index-organized tables. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone

Re: CHAINED ROWS

2002-01-09 Thread Charlie Mengler
. Mike From: SARKAR, Samir [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: CHAINED ROWS Date: Wed, 09 Jan 2002 01:56:54 -0800 Thanks Jacques...forgot about the Index-organized tables. Samir Samir Sarkar Oracle

CHAINED ROWS

2002-01-08 Thread Bunyamin K. Karadeniz
I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin

RE: CHAINED ROWS

2002-01-08 Thread Robertson Lee - lerobe
of list ORACLE-LSubject: CHAINED ROWS I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin The information contained in this communication is confidential, is intended only

RE: CHAINED ROWS

2002-01-08 Thread SARKAR, Samir
If Oracle 8i is ur current version, run the utlchain1.sql script available in ur ORACLE_HOME/rdbms/admin directory. This will create the chained_rows table for u. Now analyze the affected table using the command : analyze table table_name list chained rows into chained_rows; Now when u

RE: CHAINED ROWS

2002-01-08 Thread Babich , Sergey
ROWS I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin

RE: CHAINED ROWS

2002-01-08 Thread Orr, Steve
Just analyze table xxx list chained rows and use the procedure titled Reducing Migrated and Chained Rows in the Designing and Tuning for Performance guide, chapter 20. I've used this on large tables and it works quite well. Steve Orr, Bozeman, Montana -Original Message- Sent: Tuesday

RE: CHAINED ROWS

2002-01-08 Thread Jacques Kilchoer
Title: RE: CHAINED ROWS If your chained rows are inside an Index-Organized table, be sure to read the Oracle manual on the Analyze command. There are two versions of the chained-row table, for index-organized tables you should create the chained-row table with universal rowids (head_rowid has