LONG column in clustered table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: LONG column in clustered table

  1. #1
    Join Date
    Apr 2001
    Posts
    47

    Angry LONG column in clustered table

    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.

    SQL Sample:-
    ------------
    create cluster image_clu (store# number, image# number);
    create index image_clu_i on cluster image_clu;

    create table image(image# number,
    image long,
    description varchar2(2000),
    store# number)
    cluster image_clu(store#, image#);

    create table image2(image# number,
    name char(50),
    store# number)
    cluster image_clu(store#, image#);

    insert into image values(1,5,9,3);
    insert into image values(1,6,9,1);
    insert into image values(2,7,9,1);
    insert into image values(2,8,9,0);

    insert into image2 values(1,9,0);
    insert into image2 values(1,9,1);
    insert into image2 values(1,9,3);
    insert into image2 values(2,9,3);

  2. #2
    Join Date
    Apr 2001
    Posts
    47
    Gurus,

    Could anyone throw some light on it.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width