Hi All,
I have two tables which have have two columns whose datatype is of LONG and LONG RAW.I always see that there are chained rows in these tables.Is there any way to remove the chained rows?
TIA
Mike
Printable View
Hi All,
I have two tables which have have two columns whose datatype is of LONG and LONG RAW.I always see that there are chained rows in these tables.Is there any way to remove the chained rows?
TIA
Mike
Not realy. If the values in those LONG and LONG RAW columns are bigger than your database block size, then there is no way to avoid row chaining.
Your best option would be to change those columns to LOBS so that you can specify sepparate storage segments for them, thus avoiding excessive recursive I/Os for other columns in those tables when you don't need those LONG/LONGRAW columns.
If the DB contains more images or spatial data, then consider increase DB_BLOCK_SIZE. This option may not be a real solution if only a couple of tables have LONG columns.