1 2 Previous Next 15 Replies Latest reply: Dec 12, 2012 11:07 PM by 826457 RSS

    Impdp error - import made packages and procedures invalid..

      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