+ Reply to Thread
Results 1 to 2 of 2
  1. 12-12-2001 09:08 AM #1
    aph
    aph is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 12-12-2001 11:08 AM #2
    TimHall
    TimHall is offline Senior Advisor
    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: www.oracle-base.com
    My blog: www.oracle-base.com/blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width