ORA 1652 "unable to extend temp segment by %s in tablespace %s"

Note:19047.1[@more@] Error: ORA-1652
Text: unable to extend temp segment by %s in tablespace %s
------- -----------------------------------------------------------------------
Cause: Failed to allocate an extent for temp segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated or create the object in another
tablespace.

*** Important: The notes below are for experienced users - See
Note 22080.1


Explanation:
This error is fairly self explanatory - we cannot get enough space for
a temporary segment. The size reported in the error message is
the number of contiguous free Oracle blocks that cannot be found
in the listed tablespace.

NOTE: A "temp segment" is not necessarily a SORT segment in a
temporary tablespace.
It is also used for temporary situations while creating or dropping
objects like tables and indexes in permanent tablespaces.
eg: When you perform a CREATE INDEX a TEMP segment is created
to hold what will be the final permanent index data. This
TEMP segment is converted to a real INDEX segment in the
dictionary at the end of the CREATE INDEX operation. It remains
a temp segment for the duration of the CREATE INDEX operation
and so failures to extend it report ORA-1652 rather than an
INDEX related space error.


A TEMPORARY segment may be from:
A SORT Used for a SELECT or for DML/DDL

CREATE INDEX The index create performs a SORT in the users
default TEMP tablespace and ALSO uses a TEMP
segment to build the final index in the INDEX
tablespace. Once the index build is complete
the segment type is changed.

CREATE PK CONSTRAINT

ENABLE CONSTRAINT

CREATE TABLE New tables start out as TEMPORARY segments.
Eg: If MINEXTENTS is > 1 or you issue
CREATE table as SELECT.

Accessing a GLOBAL TEMPORARY TABLE
When you access a global temporary table
a TEMP segment is instantiated to hold the
temporary data.

It is worth making sure the TEMP tablespace PCTINCREASE is 0 and
that it has a sensible (large) storage clause to prevent fragmentation.
For TEMPORARY temp tablespaces make sure both INITIAL and NEXT are
set to large values as extent sizes are taken from the NEXT clause
and not the INITIAL clause.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7794469/viewspace-887302/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/7794469/viewspace-887302/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值