DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: interim tables ?

  1. #1
    Join Date
    Jul 2001
    Posts
    334
    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.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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!
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width