Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> create interMedia index problem

create interMedia index problem

From: Guang Mei <gmei_at_incyte.com>
Date: Thu, 27 Mar 2003 20:53:35 -0800
Message-ID: <F001.00574EF7.20030327205335@fatcity.com>


Hi:

I have this problem on our production server and I don't know too much about InterMedia stuff. We have oracle 8173 on Sun Solaris 2.8.

ISI_at_remax-SQL> desc DRUGDATA;

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 ID                                        NOT NULL NUMBER
 DRUGREPID                                 NOT NULL NUMBER
 FIELD                                     NOT NULL NUMBER
 TEXT                                               VARCHAR2(4000)
 DRUGTERMID                                         NUMBER
 DATATYPEID                                NOT NULL NUMBER
 ADD_FILE                                  NOT NULL VARCHAR2(32)
 ADD_DATE                                  NOT NULL DATE
 DEL_FILE                                           VARCHAR2(32)
 DEL_DATE                                           DATE
 STATUS                                    NOT NULL CHAR(1)
 ORDERBY                                   NOT NULL NUMBER

ISI_at_remax-SQL> select count(*) from DRUGDATA;

  COUNT(*)


         0

TABLESPACE_NAME USED-Kb ALLOC-Kb USED% SEGS >EXT >NEXTEXT

-------------------- ----------- ----------- ------ ----- ----- --------
DATA                       3,000   1,048,576     .3     1     1      504
INDEXES               10,664,424  14,680,064   72.6   480    11  693,080
PERFSTAT                 105,728   2,097,152    5.0    56   150      128
PROTEOME                 164,872   1,048,576   15.7    52    19   25,600
RBS                    5,131,360   8,388,608   61.2     6   800    2,048
RESCTX                    43,832   6,803,456     .6    66    28      504
RESDATA               34,470,408  46,137,344   74.7   361  2319 ########
RESINDEX              41,046,376  69,206,016   59.3   300  1063  512,000
SYSTEM                    74,320     153,600   48.4   401   115    1,120
TEMP                  10,224,960  10,240,000   99.9     1  2045    5,000
YPD                   12,769,224  16,777,216   76.1   249 #####  292,976

TABLESPACE_NAME      USED-Kb     ALLOC-Kb    USED%  SEGS  >EXT  >NEXTEXT
-------------------- ----------- ----------- ------ ----- ----- --------
YPDCUST                        0   1,048,576     .0     0     0        0

Then I ran

create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT)  indextype is ctxsys.context
parameters ('LEXER ctxsys.ISILEX WORDLIST ctxsys.ISIWORDLIST STOPLIST ctxsys.ISISTOP storage isistore memory 50M');

I got

create index DRUGDATAINDEX_TEXT on DRUGDATA (TEXT) *
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_index_tables
ORA-01658: unable to create INITIAL extent for segment in tablespace
RESINDEX
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1

and I got from alert_log file:

ORA-1652: unable to extend temp segment by 128000 in tablespace RESINDEX I did coalesce on all tablespace and added another 2G datafile on RESINDEX tablespace, I still got the same error. BTW, I could run the same sql on two other DEV instances without any problem. The RESINDEX ts on them are much more filled (like 90% full).

Any idea what might be the problem? TIA.

Guang

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 27 2003 - 22:53:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US