ALTER DATABASE - Manually increasing or decreasing size of datafile - Oracle Datafiles and Tempfiles

Q.  Which statement we used for manually increasing or decreasing the size of a datafile?
- Published on 27 Jul 15

a. ALTER DATABASE
b. ALTER TABLESPACE
c. CREATE DATABASE
d. CREATE TABLESPACE

ANSWER: ALTER DATABASE
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - You can manually increase or decrease the size of a datafile using the ALTER DATABASE statement.

    - Because you can change the sizes of datafiles, you can 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.

    - Manually reducing the sizes of datafiles allows you to reclaim unused space in the database.

    - This is useful for correcting errors in estimates of space requirements.

    - ALTER TABLESPACE - Use the ALTER TABLESPACE statement to alter an existing tablespace or one or more of its datafiles or tempfiles.

    - CREATE TABLESPACE - Use the CREATE TABLESPACE statement to create a tablespace, which is an allocation of space in the database that can contain schema objects.

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.)