CODEWITHSUNDEEP
oracle-databaseimpdp
Bilel Chaouadi
Bilel Chaouadi

Reputation: 933

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

Upvotes: 2

Views: 8107

Answers (3)

Balu B
Balu B

Reputation: 71

Open SQL Developer. Set the PLScope identifiers parameter (Tools > Preferences > Database > PL/SQL Compiler > PLScope identifiers) from All to None. Close and open the SQL Developer.

It solved my issue.

Upvotes: 7

Bilel Chaouadi
Bilel Chaouadi

Reputation: 933

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

Upvotes: 0

R. Du
R. Du

Reputation: 633

In the support note mentioned above, Oracle says that this error is related to SQL Developer and a specific patched version of Oracle DB (12.2.0.1.181016).

As a workaround it seems you can disable PL/Scope (a functionality to parse and analyse PL/SQL code) like this :

  • Open SQL Developer Set the PLScope identifiers parameter (Tools > Preferences > Database > PL/SQL Compiler > PLScope identifiers) from All to None.
  • Close and open the SQL Developer

Upvotes: 3

Related Questions