interim tables ? Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: interim tables ?

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

    I assume this is what you mean!
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website:
    My 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