Database Administration (MOSC)

MOSC Banner

IOT Manitenance

edited Sep 3, 2009 3:44AM in Database Administration (MOSC) 4 commentsAnswered
In order to defrag a few IOTs in our system, we are planning to use "alter table move".
Questions:
1/ Is "alter table move" an optimal way to defrag an Index Organized Table?
2/ All IOTs have constraints and triggers. What do we need to do to avoid any issues such as data corruption while running "alter table move"
3/ Can "alter table move" be done online?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center