1 2 Previous Next 15 Replies Latest reply on Nov 19, 2012 2:25 PM by crs13 Go to original post
      • 15. Re: Datapump and error on virtual columns (second)
        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),
        <storage parameters here>
        *<special characters>ALTER TABLE "TABLESPACE_MIGRATIONS" MODIFY ("VIRTUALCOLUMN" DEFAULT <expression/function for virtual column>)*
        INSERT INTO "mytable" ...
        1 2 Previous Next