Chapter 10. Allocating Database Storage and Creating Schema Objects

ORACLE DATABASE 11g: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Managing Database Storage Structures

    • Overview of tablespace and datafiles

    • Create and manage tablespaces

    • Space management in tablespaces

  • Managing Schema Objects

    • Create and Modify tables

    • Manage Constraints

    • Create indexes

    • Create and use temporary tables

Allocating Database Storage and Creating Schema Objects

In this chapter, you will learn more about the physical and logical storage structures. To start, you'll explore how a tablespace is the highest level of logical structure in an Oracle Database 11g, whereas a data file is a physical structure that is associated with ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial