Managing Tablespaces

Abstract

In the next chapter, you’ll learn how Oracle DBAs create and manage the schema objects, which include tables, indexes, views, materialized views, synonyms, triggers, database links, and so on. Before we look at the various schema objects, though, you need to learn how to manage the all-important Oracle tablespaces. As you learned in Chapter 5, tablespaces are logical entities—each of an application’ tables and indexes are stored as a segment, and the segments are stored in the data-files that are parts of tablespaces. A tablespace is thus a logical allocation of space for Oracle schema objects. There is, however, no one-to-one correspondence between a schema object like a table or index and a tablespace.