Jump to Navigation

165 - Alter Oracle for autoextend on

Recommend using locally-managed tablespaces (extent management local) and automatic segment storage management
(segment space management auto).

The following command script will alter a data file to "autoextend on" removing the potential for "object cannot extend"
and "unable to allocate extent" errors and placing the onus on the DBA to monitor the OS file system to have enough
room for data file growth.

SQL> alter database datafile '/d01/app/oracle/oradata/prod/user_01.dbf'  autoextend on;


Main menu 2

Story | by Dr. Radut