I am trying to import a dump file from an 11g database into a 19c database instance. I am running the job as SYSTEM as recommended by Oracle. The job starts but quickly devolves into failing SQL errors that all share the same:
ORA-54002: only pure functions can be specified in a virtual column expression.
I have done some research on that error and have found some indications that this was an issue or bug solved after Oracle 12. The following blog addresses the issue:
…and discusses a workaround that invloves recoding the SQL.
I am creating a DDL file from the dump to give me all the code to work with.
My questions are:
- Is there an alternative to re-writing all the code in the dump file and running that against the impdp job?
- Is that even a possibility?
- Are there other options for creating a new dump file from the 11g instance that can work with the impdp into 19c?