catalog index - ctxcat

[anandkl]

Hi Friends,
I am trying to create a catalog index. Oracle version is 8.1.7.4.
Below is the script i am using.

When i am creating the index i am getting below error. Can u please guide me how to solve this.

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50857: oracle error in drixtab.create_ctxcat_indexes:01
ORA-02158: invalid CREATE INDEX option
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 73
ORA-06512: at line 1






SQL> exec ctx_ddl.create_index_set('sfitemset');

PL/SQL procedure successfully completed.



SQL> SQL> exec ctx_ddl.add_index('sfitemset','buy_it_price','quantity_live');

PL/SQL procedure successfully completed.

begin
ctx_ddl.create_preference('ctx_storage', 'BASIC_STORAGE');
ctx_ddl.set_attribute('ctx_storage', 'I_TABLE_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');
ctx_ddl.set_attribute('ctx_storage', 'K_TABLE_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');
ctx_ddl.set_attribute('ctx_storage', 'R_TABLE_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');
ctx_ddl.set_attribute('ctx_storage', 'N_TABLE_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');
ctx_ddl.set_attribute('ctx_storage', 'I_INDEX_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');
ctx_ddl.set_attribute('ctx_storage', 'P_TABLE_CLAUSE',
'tablespace data3 storage (initial 10M next 10M pctincrease 0)');

end;

create index sfitem_ctx on sims(title) indextype is ctxsys.ctxcat
parameters ('storage ctx_storage index set sfitemset');

regards
anandkl

[anandkl]

Hi All,
I was able to excute the command successfully.
I just had to do this

exec ctx_ddl.add_index('sfitemset','buy_it_price')
exec ctx_ddl.add_index('sfitemset','quantity_live');

rather than

exec ctx_ddl.add_index('sfitemset','buy_it_price','quantity_live');

Thank you all.

regards
anandkl