Re: ORA-1652: unable to extend temp segment

You don't have enough space in tablespace IMI_NDX which you are using as a temp tablespace. Why? Well, you said compress=Y and that means for each object that you import start with an initial size (extent) that is equal to the total size in the old instance. But an extent must be a contigous set of blocks and an extent cannot span a physical file.

You need to make the IMI_NDX space larger.

Jim

--
Our new email address is kennedy-family_at_home.com
.
"Vadim Grepan" <kezal_at_mail.ru> wrote in message news
:3A8A4CC6.52A79A3_at_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 ?

>

> === Error message from alert.log ===

> . . .

> ORA-1652: unable to extend temp segment by 38400 in tablespace

> IMI_NDX

> . . .

> === ===

>

> 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

> . . .

>

> === cut ===

>

> Rgds, Vadim Grepan

> ------------------------

> Moscow, Russia

>

>