oracle 11g管理篇

Locally Managed Tablespaces.......................................................................................................14-3 Bigfile Tablespaces..........................................................................................................................14-6 Compressed Tablespaces...............................................................................................................14-8 Encrypted Tablespaces...................................................................................................................14-8 Temporary Tablespaces................................................................................................................14-10 Multiple Temporary Tablespaces: Using Tablespace Groups................................................14-13 Specifying Nonstandard Block Sizes for Tablespaces.................................................................14-14 Controlling the Writing of Redo Records.......................................................................................14-15 Altering Tablespace Availability .....................................................................................................14-15 Taking Tablespaces Offline..........................................................................................................14-15 Bringing Tablespaces Online.......................................................................................................14-17 Using Read-Only Tablespaces..........................................................................................................14-17 Making a Tablespace Read-Only................................................................................................14-18 Making a Read-Only Tablespace Writable ...............................................................................14-19 Creating a Read-Only Tablespace on a WORM Device..........................................................14-20 Delaying the Opening of Datafiles in Read-Only Tablespaces..............................................14-20 Altering and Maintaining Tablespaces...........................................................................................14-21 Increasing the Size of a Tablespace.............................................................................................14-21 Altering a Locally Managed Tablespace....................................................................................14-21 Altering a Bigfile Tablespace.......................................................................................................14-21 Altering a Locally Managed Temporary Tablespace...............................................................14-22 Shrinking a Locally Managed Temporary Tablespace............................................................14-23 Renaming Tablespaces.......................................................................................................................14-23 Dropping Tablespaces .......................................................................................................................14-24 Managing the SYSAUX Tablespace.................................................................................................14-25 Monitoring Occupants of the SYSAUX Tablespace.................................................................14-25 Moving Occupants Out Of or Into the SYSAUX Tablespace..................................................14-25 Controlling the Size of the SYSAUX Tablespace......................................................................14-25 Diagnosing and Repairing Locally Managed Tablespace Problems.........................................14-26 Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)............14-28 Scenario 2: Dropping a Corrupted Segment.............................................................................14-28 Scenario 3: Fixing Bitmap Where Overlap is Reported...........................................................14-28 Scenario 4: Correcting Media Corruption of Bitmap Blocks...................................................14-28 Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed Tablespace......14-29 Migrating the SYSTEM Tablespace to a Locally Managed Tablespace....................................14-29 Transporting Tablespaces Between Databases..............................................................................14-30 Introduction to Transportable Tablespaces...............................................................................14-30 About Transporting Tablespaces Across Platforms.................................................................14-31 Limitations on Transportable Tablespace Use..........................................................................14-32 Compatibility Considerations for Transportable Tablespaces...............................................14-34 Transporting Tablespaces Between Databases: A Procedure and Example........................14-35 Using Transportable Tablespaces: Scenarios............................................................................14-44 Moving Databases Across Platforms Using Transportable Tablespaces..............................14-47 Tablespace Data Dictionary Views..................................................................................................14-47 Example 1: Listing Tablespaces and Default Storage Parameters.........................................14-48 Example 2: Listing the Datafiles and Associated Tablespaces of a Database.......................14-48 Example 3: Displaying Statistics for Free Space (Extents) of Each Tablespace....................14-49 xii