oracle-databaseimpdp

Impdp ora-00904 invalid identifier

I'm triying to import our database which is in WE8MSWIN1252 instance to a new AL32UTF8 instance. I'm using impdp tool to achieve this. I get the following error

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC ORA-39083: Object type ALTER_PACKAGE_SPEC:"MyOwner"."MyPackageOwner" failed to create with error: ORA-00904: "DECL_OBJ#": invalid identifier

Please note that when I compile this package using SQLplus it is working as expected Do you have any idea about what can causes this error ? Thanks, Bilel

Solution

  • I have just excluded views, packages and package_compile from the export and this worked as expected.