Using New Online Redefinition Features

 

Page 38

movement command. The cascade option can also extend to overflow segments of nonpartitioned or partitioned IOTs. You cannot shrink the following objects:

image Tables that are in clusters

image Any table with a Long column

image A table with an on-commit materialized view

image Any table with a ROWID-based materialized view

image A LOB index

image IOT mapping tables and IOT overflow segments

image Shared LOB segments

image Temporary and Undo segments

The shrink operation actually takes part in two stages. The first stage is the compaction of the data in the table. The second stage is the dropping of the high-water mark located in the table. You can perform just the compaction of the data if you like by using the compact clause of the alter command, as shown in this example:

 Alter table my_table shrink space cascade compact; 

NOTE
Shrinking/compacting of a table or an IOT is the same as coalescing that object.

Using New Online Redefinition Features

Oracle9i introduced the ability to rebuild an Oracle table online, reducing outages associated with rebuild operations. Oracle Database 10g improves on this functionality. First, Oracle Database 10g allows you to redefine tables with CLOB and BLOB data types (but not BFILE). Also, master-master replicated tables can now be redefined online, within a somewhat restrictive set of limitations. Finally, you can now instruct Oracle on how to order the rows when you perform the initial instantiation of the interim table through the use of the orderby_cols parameter when the dbms_redefinition.start_redef_table procedure is called.

 


Oracle Database 10g New Features
Oracle Database 10g New Features (Osborne ORACLE Press Series)
ISBN: 0072229470
EAN: 2147483647
Year: 2006
Pages: 80

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net