1 2 Previous Next 15 Replies Latest reply on Nov 19, 2012 2:25 PM by crs13

    Datapump and error on virtual columns (second)

      I've asked for that problem already two month ago.

      The problem:
      I've some tables with calculated/virtual columns. And we use DataPump to copy the real data on a testing machine.
      All tables with calculated columns are empty due to an error (ORA-31693 → ORA-54013).
      Now I've two choices:
      not to use virtual columns in dayly work
      or transfer the lost data by handmade INSERT-statements.

      Now I've found a discussion in an other forum and they mentioned a bug 6357106.
      Is it possible to see this bug?
      Are there other people that suffers on it?
      Is there any hope for a solution next month?


      I recently used expdp (Export Datapump) to export a schema to another Database.
      When I used impdp (Import Datapump) the insert failed for the table containing a Virtual Column.
      ORA-31693: Table data object "SCHEMA"."TABLENAME" failed to load/unload and is being skipped due to error:
      ORA-54013: INSERT operation disallowed on virtual columns
      Are there any plans anyone knows of that to fix this? If not, then what would be the explanation as to why?
      Satish Kandi:
      Metalink reveals this to be classified as a bug 6357106 for (under different circumstances) and there is no fix available yet.
        1 2 Previous Next