Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle AUTOEXTEND Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: AUTOEXTEND

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:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 71 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?