Autoextend syntax

Note the order of maxsize and next, has to be specified in that order, a little annoyingly:

alter database datafile 'FILENAME' autoextend on next 1024m maxsize 3072m ;

alter tablespace TSNAME add datafile 'FILENAME' size 1024m autoextend on next 1024m maxsize 3072m ;

From 10gR1 and above you can specify sizes in g. With 9i and below, you are stuck with sizes in m, like the above.

This entry was posted in Space. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>