UNABLE TO EXTEND Errors

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博客 ” ，链接：http://blog.itpub.net/8684388/viewspace-617208/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8684388/viewspace-617208/