Table of ContentsManaging Tablespaces and Data Files Objectives Overview PPT Slide SYSTEM and Non-SYSTEM Tablespaces Creating Tablespaces Storage Parameters Temporary Tablespace Adding Data Files to a Tablespace Enabling Automatic Extension of Data Files PPT Slide Changing the Storage Settings OFFLINE Status Moving Data Files: ALTER TABLESPACE Moving Data Files: ALTER DATABASE The READ-ONLY Tablespace Status Making Tablespace Read-Only Dropping Tablespaces Obtaining Tablespace Information Obtaining Data File Information Obtaining Data File and Tablespace Information from the Control File Guidelines Summary |
Author: Julie Rose Email: melody@ecst.csuchico.edu Home Page: http://www.ecst.csuchico.edu/~melody |