Chapter 12. Managing Tables


Terms you'll need to understand:

  • External tables

  • Partitioned tables

  • Cluster tables

  • Regular tables

  • Index-organized tables

  • Truncate

  • ALTER TABLE

  • Scalar data types

  • User-defined data types

  • LOBs

  • ROWID

Concepts you'll need to master:

  • Identify the various methods of storing data.

  • Identify Oracle data types.

  • Distinguish between extended and restricted ROWID.

  • Identify the structure of a row.

  • Create regular and temporary tables.

  • Manage the storage structures within a table.

  • Reorganize, truncate, and drop tables.

  • Drop columns within a table.

  • Rename a column within a table.

  • Move tables from one tablespace to another.

As a database administrator, you will likely spend a considerable amount of time managing tables or managing objects surrounding tables. This chapter provides an overview of the different kinds of tables you will encounter both on your exam and in your Oracle 9i DBA career.

Tables are the way that Oracle, and other relational databases, store data. This means that tables are a key component of the database and one of the most important to your users, and by extension tables will be very important to you. No tables, no data; no data, no need for a DBA.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net