Reference ==============================

Doc ID:

1025288.6

Problem ============================

UNABLE TO EXTEND Errors

Resolution ===============================

1. 对于字典管理表空间，检查并降低问题段的 next_extent 和 pct_increase （在 dba_segments 中）。

D. Lower "next_extent" and/or "pct_increase" size if segment is in a Dictionary Managed Tablespace

For non-temporary and non-partitioned segments:

ALTER STORAGE ( next pctincrease );

For non-temporary and partitioned segments:

ALTER TABLE MODIFY PARTITION STORAGE ( next pctincrease );

For a temporary segment problem:

ALTER TABLESPACE DEFAULT STORAGE (initial next pctincrease );

2. 对于本地管理表空间，无论是auto allocate 还是 uniform，next_extent 和 pct_increase 不起作用，可以：

A. Manually Coalesce Adjacent Free Extents

ALTER TABLESPACE COALESCE;

The extents must be adjacent to each other for this to work.

B. Modify one or more datafiles in the tablespace to use AUTOEXTEND

ALTER DATABASE DATAFILE '' AUTOEXTEND ON MAXSIZE ;

NOTE: It is strongly recommended that MAXSIZE be specified to try to prevent the datafile from consuming all available space on the volume

C. Add a Datafile

ALTER TABLESPACE ADD DATAFILE '' SIZE ;

E. Resize the Datafile

ALTER DATABASE DATAFILE '' RESIZE ;

ITPub博客

UNABLE TO EXTEND Errors

D. Lower "next_extent" and/or "pct_increase" size if segment is in a Dictionary Managed Tablespace

A. Manually Coalesce Adjacent Free Extents

B. Modify one or more datafiles in the tablespace to use AUTOEXTEND

C. Add a Datafile

最新文章