ORA-1652: unable to extend temp segment 
Author Message
 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 ?

=== 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



Sun, 03 Aug 2003 17:15:50 GMT
 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

--

.

Quote:
> 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



Sun, 03 Aug 2003 21:29:53 GMT
 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
------------------------
Moscow, Russia

Quote:

> 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

> --

> .


> > 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



Sun, 03 Aug 2003 23:07:04 GMT
 ORA-1652: unable to extend temp segment
It is not strange, but also not well known:
*all* indexes are created as temporary segment in the target tablespace.
After the temporary segment has been created it is renamed to the index name
you specified.

So before that you would get 1652, after the index creation when it should
fail to extend the usual errors.

Hope to have filled in the 'gap'

Regards,

Sybrand Bakker, Oracle DBA


Quote:
> Hello!

>   Thanks for your answer.

> It's strange because no one user doesn't have this tablespace as
temporary.

> Rgds, Vadim Grepan
> ------------------------
> Moscow, Russia


> > 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

> > --

> > .


> > > 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



Tue, 05 Aug 2003 14:35:14 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ORA-1652: unable to extend temp segment by 7680 in tablespace

2. ORA-1652: unable to extend temp segment by 8192 in tablespace

3. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

4. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

5. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

6. ORA-01652 unable to extend temp segment by num in tablespace name

7. ORA-01652: unable to extend temp segment by 1598 in tablespace

8. ORA-01652: unable to extend temp segment by 1598 in tablespace

9. 01652: unable to extend temp segment

10. Unable to extend temp segment...

11. extend temp segment - ora 01652


 
Powered by phpBB® Forum Software