Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-1652: unable to extend temp segment
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 tablespaceIMI_NDX
ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78 ORA-06512: at line 1
Rgds, Vadim Grepan