How do i extend tablespace in oracle

This is useful for correcting errors in estimates of space requirements. However, because its tablespace now stores smaller objects, the datafile can be reduced in size.

Skip Headers. Changing Datafile Size This section describes the various ways to alter the size of a datafile, and contains the following topics: Enabling and Disabling Automatic Extension for a Datafile Manually Resizing a Datafile Enabling and Disabling Automatic Extension for a Datafile You can create datafiles or alter existing datafiles so that they automatically increase in size when more space is needed in the database.

The next example disables the automatic extension for the datafile. Author: Priyashantha Fernando. Created on: 26 June BRI Choice menu 1 — please make a selection. Standard keys: c — cont, b — back, s — stop, r — refr, h — help. BRI Enter your choice:.

BRI Choice menu 5 — please make a selection. Database space management. BRI Program execution will be continued…. BRI Choice menu — please make a selection. Tablespace extension main menu. The value of NEXT is the minimum size of the increments added to the file when it extends. This enables you to add more space to your database without adding more datafiles. This is beneficial if you are concerned about reaching the maximum number of datafiles allowed in your database.

And of course, keep up to date with AskTOM via the official twitter account. Questions changing size of a tablespace. Question and Answer. You Asked what is the way of changinng max size of a tablespace. A reader, May 09, - am UTC. Now as you mentioned that "never growing a file over 2gig. December 24, - am UTC. I said in most cases i PREFER to keep the file at 2gig or less as all OS utilities will work with 2gig and less files, some will not and not all file systems support files over 2gig.

However, if I'm working on a really big database -- hundreds of gigabytes -- large files will be something to consider. A reader, May 06, - pm UTC.