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

Home -> Community -> Usenet -> c.d.o.server -> ORA-1652: unable to extend temp segment

ORA-1652: unable to extend temp segment

From: Vadim Grepan <kezal_at_mail.ru>
Date: Wed, 14 Feb 2001 12:15:50 +0300
Message-ID: <3A8A4CC6.52A79A3@mail.ru>

Hello All!
I've moved scheme from 8.1.6 instance to 8.1.7 instance. Export has been done with options COMPRESS=Y and ROWS=N. During import i've got ORA-01658 for all interMedia indexes, meanwhile datafiles are the same size as on old instance.

All tablespaces are coalesced.
Will reducing default INITIAL segment help ?

Here is export error message:
=== cut ===
. . .

IMP-00017: following statement failed with ORACLE error 29855:  "CREATE INDEX "NDX_AUTHOR_FULL_NAME" ON "TBL_AUTHOR" ("AUTHOR_FNAME" ) INDE"
 "XTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('sync memory 20M')"

IMP-00003: ORACLE error 29855 encountered
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
IMI_NDX
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1

. . .

Rgds, Vadim Grepan



Moscow, Russia Received on Wed Feb 14 2001 - 03:15:50 CST

Original text of this message

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