Definition:
In Oracle PL/SQL, the term AUTOEXTEND is used in conjunction with datafiles and tablespaces, and tells Oracle to automatically allocate and expand the space used to a specified limit. When the UNLIMITED modifier is used, Oracle can use all available space on the device.
For most databases the problem of tablespaces filling up can be avoided by using the AUTOEXTEND capability and allowing the datafiles to expand automatically. For applications that could consume all free space available (unless a hard limit is enforced), the MAXSIZE option can be used in conjunction with AUTOEXTEND as a fallback or "safety net".
Related Links:
