This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Dec 12, 2012 9:07 PM by 826457 RSS

Impdp error - import made packages and procedures invalid..

khallas301 Newbie
Currently Being Moderated
Hi all,

db: 11g

I have import dumpfile for schema refresh but when import completes it made many packages and procedures invalid....
Package compilation error:
pl/sql: Declaration ignore
PLS-00201: identifier 'schema_T_Dump.em_id' must be declared..

I have tried all sort of compilation things but still packages are invalid..
I think type is missing in target database from source...

don't have Toad or SQL developer for review....

any quick tips.. I am going clueless


Edited by: khallas301 on Dec 4, 2012 7:03 AM
1 2 Previous Next


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