This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Nov 19, 2012 6:25 AM by crs13 Go to original post RSS
  • 15. Re: Datapump and error on virtual columns (second)
    crs13 Newbie
    Currently Being Moderated
    There are better workarounds in this thread, but if you get stuck with a EXP/IMP .dmp file that won't import do to a virtual column, it is possible to tweak the file to reimport as a physical column if you really need the data in there.

    If you text search for the "CREATE TABLE" statement, there should be alters that try to make the column virtual (bolded). Deleting those lines will allow you to IMP the table data, though you will still need to deal with the structure of the virtual column afterwards:

    TABLE "mytable"
    CREATE TABLE "mytable" (
    "column1" VARCHAR2(30) NOT NULL ENABLE,
    "column2" VARCHAR2(30),
    "VIRTUALCOLUMN" NUMBER)
    <storage parameters here>
    ALTER TABLE "TABLESPACE_MIGRATIONS" MODIFY DEFAULT
    *<special characters>ALTER TABLE "TABLESPACE_MIGRATIONS" MODIFY ("VIRTUALCOLUMN" DEFAULT <expression/function for virtual column>)*
    INSERT INTO "mytable" ...
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points