Automic Community

Oralce DB Re-Platform

  • 1.  Oralce DB Re-Platform

    Posted 03-19-2019 07:55 AM

    We have migrated Appworx dev database from Solaris to new platform (Linux) and all objects are valid except the one mentioned below.

    SQL> @/orabkup/orauksm1/scripts/chk_invalid.sql

     

      COUNT(*)

    ----------

             1

      COUNT(*) OWNER

    ---------- --------------------------------------------------------------------------------------------------------------------------------

             1 APPW_UK

     

    SQL> alter package APPW_UK.AW_TOOLS compile body;

     

    Warning: Package Body altered with compilation errors.

     

    SQL> show error

    Errors for PACKAGE BODY APPW_UK.AW_TOOLS:

    791/1    PL/SQL: SQL Statement ignored

    796/22   PL/SQL: ORA-00942: table or view does not exist

    827/20   PL/SQL: SQL Statement ignored

    832/27   PL/SQL: ORA-00942: table or view does not exist

    836/13   PL/SQL: Statement ignored

    836/18   PLS-00364: loop index variable 'Y' use is invalid

    856/1    PL/SQL: SQL Statement ignored

    860/74   PL/SQL: ORA-00942: table or view does not exist

    867/1    PL/SQL: SQL Statement ignored

    867/45   PL/SQL: ORA-00942: table or view does not exist

    873/12   PL/SQL: Statement ignored

    873/64   PLS-00364: loop index variable 'REC' use is invalid

    874/9    PL/SQL: Statement ignored

    874/17   PLS-00364: loop index variable 'REC' use is invalid

    876/12   PL/SQL: Statement ignored

    876/64   PLS-00364: loop index variable 'REC2' use is invalid

     

    This package body is encrypted hence unable to view the code to identify the missing table/view/grant.

    Has anyone encountered the similar issue?

    Please help, let me know if you need any further details.

     

    Regards

     

    Pankaj