Table of ContentsManaging Tables Objectives Storing User Data Structure of a Row Oracle Data Types Data Types for Storing Large Objects ROWID Data Type Restricted ROWID Collections Creating a Table Creating a Table: Guidelines Setting PCTFREE and PCTUSED Row Migration and Chaining Copying an Existing Table Changing Storage and Block Utilization Parameters Manually Allocating Extents High Water Mark Finding the High Water Mark: DBMS_SPACE.UNUSED_SPACE Deallocation of Unused Space Truncating a Table Dropping Tables Validating Table Structure Detecting Row Migration Retrieving Table Information Retrieving Extent Information DBMS_ROWID Package Summary |
Author: Oracle Email: melody@ecst.csuchico.edu Home Page: http://www.ecst.csuchico.edu/~melody |