I have a clustered table(Index cluster) which contains a LONG column. But this column is not part of cluster key. Problem is when I do select on this particular LONMG column it is returning null rows. But in the creation of cluster and insertion there are no errors.
Length of the LONG column is also very less.
Also in the same sql session if I update the LONG column, I'm seeing junk data on select to this column.
Environment : AIX43 and Oracle 8.1.7
If anyone knows workarround for this, please share your tips here.
create cluster image_clu (store# number, image# number);
create index image_clu_i on cluster image_clu;