We are performing the following steps for reorg:
1> alter table x move;
2> alter index y rebuild;
Do we need to recreate all the concerned VIEWS for these tables?
You do not need to recreate the views. If the view is INVALID due to the move, it will be automatically recompiled and validated the next time the view is accessed.
1> alter table x move;
2> alter index y rebuild;
Do we need to recreate all the concerned VIEWS for these tables?
You do not need to recreate the views. If the view is INVALID due to the move, it will be automatically recompiled and validated the next time the view is accessed.
No comments:
Post a Comment