18 Managing Tables

This chapter describes the various aspects of managing tables, and includes the following topics:

• About Tables

• Guidelines for Managing Tables

• Creating Tables

• Loading Tables

• Automatically Collecting Statistics on Tables

• Altering Tables

• Redefining Tables Online

• Auditing Table Changes Using Flashback Transaction Query

• Recovering Tables Using the Flashback Table Feature

• Dropping Tables

• Using Flashback Drop and Managing the Recycle Bin

• Managing Index-Organized Tables

• Managing External Tables

• Tables Data Dictionary Views