| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1652: unable to extend temp segment
Hello!
Thanks for your answer.
It's strange because no one user doesn't have this tablespace as temporary.
Rgds, Vadim Grepan
Jim Kennedy wrote:
> 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
> >
> >
Received on Wed Feb 14 2001 - 09:07:04 CST
 |
 |