Wikipedia

Search results

Do we need to recreate views in a table after performing an Oracle table reorg ?

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.

No comments:

Post a Comment