Chapter 3. Database Storage and Schema Objects
ORACLE DATABASE 10G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Storage Structures
Define the purpose of tablespaces and data files.
Create tablespaces.
Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write).
Obtain tablespace information from EM and the data dictionary.
Drop tablespaces.
Describe the default tablespaces.
Managing Schema Objects
Create and modify tables.
Define constraints.
View the attributes of a table.
View the contents of a table.
Create indexes and views.
Name database objects.
Select appropriate data types.
Create and use sequences.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
The Oracle Database 10g (Oracle 10g) database stores schema objects—such as tables—logically in tablespaces while physically placing them in data files. An Oracle database consists of two or more tablespaces, and each tablespace sits on one or more datafiles. When you create a table, you can tell the database which tablespace to put the table's data into.
In this chapter, you will learn how to create and manage tablespaces and about the schema objects that reside in them.