Intermedia Indexing

[Jeff6776]

I am trying to create an intermedia index. There are 180K records in the database. Does anyone know how to solve this problem? What exactly is the DRSYS tablespace?

SQL> create index IDX_GALE_COMPANY_NAME on GALE (COMPANY_NAME)
indextype is ctxsys.context
parameters ('storage my_basic_storage
stoplist my_stoplist')
/

create index IDX_GALE_COMPANY_NAME on GALE (COMPANY_NAME)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
ORA-01658: unable to create INITIAL extent for segment in tablespace DRSYS
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

 

[kmstan]

You have to specify the tablespace, this is where the index will be created and store in, and the size of the initial extent, this is to tell the database the initial size to allocate to the index.

Your query looks a bit different from what I normally used, maybe you can change your query to make it look like this:

CREATE INDEX IDX_GALE_COMPANY_NAME ON GALE_COMPANY_NAME
(

<THE FIELD TO INDEX> ASC,
<THE FIELD TO INDEX> ASC

)
storage ( initial 10M )
tablespace <PUT YOUR TABLESPACE NAME HERE>;

 

[karluk]

The ORA-01658 error typically means that the DRSYS
tablespace is full. Please check and expand it, if needed. I suppose another possibility is that you don't have a large enough quota on the tablespace.

 

[Guest_imported]

I met same problem too.

I have specify a tablespace which I created using
&quot; nolimited&quot;(size) parameter, but when I create intermedia
index, it fails with the same error message as jeff met.




wesix