Can anyone explain What are the "interim tables" ?
When, why and where it uses?
This is a new term for me.
Appreciate for this help.
Printable View
Can anyone explain What are the "interim tables" ?
When, why and where it uses?
This is a new term for me.
Appreciate for this help.
In Oracle9i interim tables are used to store altered records during an online table redifinition. The records are then merged into the redefined table so no modifications are lost. The process is similar to an online index rebuild. See:
http://www.oracle-base.com/Articles/...leRedefinition
I assume this is what you mean!