clicksor ad

Friday, October 13, 2006

Online Table reorganisation

What can be Redefined ONLINE on a Table?
----------------------------------------

A non-partitioned table can be converted into a partitioned table, and
vice versa
The organization of a table can be changed from a heap based to IOTs (Index
Organized Tables), and vice versa
Non-primary key columns can be dropped
New columns can be added to a table
Existing columns can be renamed
Parallel support can be added or removed
Storage parameters can be modified

Renaming columns is possible without using Online Redefinition in RDBMS version
9.2 with the new RENAME COLUMN clause of the ALTER TABLE statement.

Restrictions
------------
The table to be re-organized:
* Must have a primary key (restriction lifted in 9.2.0.5)
* Cannot have User-defined data types
* Cannot have FILE or LONG columns
* Cannot be clustered
* Cannot be in the SYS or SYSTEM schema
* Cannot have materialized view logs and/or
materialized views defined on them
* Cannot be an horizontal subsetting of data
* Must be re-organized within the same schema
* Looses its snapshot logs
* Can get new columns as part of the re-organization, but the
new columns must be declared NULL until the re-organization
is complete
The full article is with me but due to copyright restrictions i could not post it here .Anyone knows the URL for this article ,please let me know I shall add the link here and remove this article.
visit http://www.oracle-base.com/articles/9i/HighAvailabilityEnhancements9i.php for more info

No comments: