Error Creating a CONTEXT INDEX

[spook007]

I'm trying to create a context index, I've read the documentation for the syntax and everytime I try I get a nasty error... this is what I'm typing.

CREATE INDEX article_description_index ON article(article_description) INDEX IS CTXSYS.CONTEXT;

when I run the statement I get this error:

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixtab.create_index_tables
ORA-01658: unable to create INITIAL extent for segment in tablespace ARTICLE_TS
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 176

Any suggestions... thanks

 

[karluk]

The most common cause of ORA-01658 is a tablespace that's close to full. The create fails because there's not enough free space in the tablespace to allocate the object being created.

Please check the free spac in your ARTICLE_TS tablespace.

 

[spook007]

Thanks a million Karluk... I would have never guessed!! Increasing the size solved the prob!!