Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 10. Managing Tablespaces and Data Files

Terms you'll need to understand:

• DBA_TABLESPACES

• V$TABLESPACES

• DBA_DATA_FILES

• V$DATAFILE

• DBA_TEMP_FILES

• V$TEMPFILE

• CREATE TABLESPACE

• ALTER TABLESPACE

• ALTER DATABASE

Concepts you'll need to master:

• Describe the logical structure of the database.

• Create tablespaces.

• Alter the size of an existing database.

• Allocate space for temporary segments.

• Change the status of tablespaces.

• Change storage settings of tablespaces.

• Implement tablespaces with Oracle Managed Files.

All databases are made up of one or more tablespaces. The single absolutely required tablespace is the SYSTEM tablespace; however, typically many other tablespaces are associated in the database. This chapter addresses the creation, deletion, and maintenance ...