NEXT - Minimum size of increments added to file when it extends - Oracle Datafiles and Tempfiles

Q.  The value of which is the minimum size of the increments added to the file when it extends?
- Published on 28 Jul 15

a. MAXSIZE
b. NEXT
c. BOTH A & B
d. NONE OF THE ABOVE

ANSWER: NEXT

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - You can enable or disable automatic file extension for existing datafiles, or manually resize a datafile, using the ALTER DATABASE statement.

    - For a bigfile tablespace, you are able to perform these operations using the ALTER TABLESPACE statement.

    - The following example enables automatic extension for a datafile added to the users tablespace:

    ALTER TABLESPACE users
    ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M
    AUTOEXTEND ON
    NEXT 512K
    MAXSIZE 250M;

    - NEXT is the minimum size of the increments added to the file when it extends.

    - MAXSIZE is the maximum size to which the file can automatically extend.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲