Re: Index key length formula for avoiding ORA-01450
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 Sep 2012 11:24:17 +0100
Message-ID: <0901C8AFD84D4D55A88B9756E96B844E_at_Primary>
Date: Tue, 18 Sep 2012 11:24:17 +0100
Message-ID: <0901C8AFD84D4D55A88B9756E96B844E_at_Primary>
A couple of corrections:
The length of the full key is not stored, it's derived in the dump For columns longer than 127 bytes the column length is stored as 2 bytes, not three bytes.
The length reported in the ORA-01450 is only about the key length, and does not consider lock, flag and row directory bytes.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Buboi Adrian" <adryanbub_at_yahoo.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, September 18, 2012 10:27 AM Subject: Index key length formula for avoiding ORA-01450
| Hi list,
| I'm trying to figure out the exact formula Oracle uses when computing the
index key length (for non-FBI and FBI with NLSSORT), and I think I'm stuck
pretty close, so any help would be appreciated.
|
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 18 2012 - 05:24:17 CDT