7 Replies Latest reply: Dec 26, 2012 1:39 PM by Dean Gagne-Oracle RSS

    Import to new table that has additional fields

      Hi Everyone,

      I am trying to migrate a table to a new table that has the field sequence changed and also has a new field added. My main question is if it is possible to have datapump add values to the new field in the target table.

      For example:

      original table has fields a, b, d, c

      new table has fields b, c, d, a, e

      I want to load the new table and also include adding values for field e. In this case, field e is a year field, so it should be loaded with '2012'

      Does datapump have the ability to do this? Is reorganizing the fields going to cause me any problems?

      We are on oracle version