Managing Tablespaces   «Prev  Next»

Adding Space - Exercise

Adding data files

Objective:Add a data file to the COIN database.

Exercise scoring

This is an auto-scored exercise worth 10 points.


The size of the tables and indexes in the USERS tablespace has grown, and you need to increase the size of the tablespace to allow for continued growth. You decide to add a data file to the tablespace.


Write a SQL statement to add a data file (in the size of your choice) to your USERS tablespace. Execute your SQL statement using Server Manager.

Submitting your exercise

This is an auto-scored exercise. You will receive full credit when you click the Submit button.