RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Managing Tablespaces
«Prev
Next»
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
archivelog-mode
archive-log-destination
naming-archive-log-files
manually-archiving-log-file
archive-log-history
archivelog-mode-conclusion
Manage Tablespace Files
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.
Background/overview
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.
Instructions
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.