Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

45
DBMS_REDEFINITION

With DBMS_REDEFINITION, you can perform an online reorganization of tables. To achieve this online reorganization, incrementally maintainable local materialized views are used. Snapshot logs need to be defined on the master tables to support incrementally maintainable materialized views. These logs keep track of the changes to the master tables and are used by the materialized views during refresh synchronization. Restrictions on the tables that can be reorganized online are as follows:

This chapter discusses the following topics:

Summary of DBMS_REDEFINITION Subprograms

Table 45-1 DBMS_REDEFINITION Subprograms
Subprogram  Description 

"CAN_REDEF_TABLE Procedure" 

Determines if a given table can be reorganized online. 

"START_REDEF_TABLE Procedure" 

Initiates the reorganization process. 

"FINISH_REDEF_TABLE Procedure" 

Completes the reorganization process. 

"SYNC_INTERIM_TABLE Procedure" 

Keeps the interim table synchronized with the original table. 

"ABORT_REDEF_TABLE Procedure" 

Cleans up errors that occur during the reorganization process. 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback