4 Replies Latest reply: Feb 10, 2010 3:14 AM by Nicolas.Gasparotto RSS

    DBMS_SQLPA - PACKAGE BODY - INVALID ?

    Nikoline
      In list of SYS invalid objects I have DBMS_SQLPA - PACKAGE BODY with INVALID status…
      What could cause this problem if I don’t make it VALID?

      Someone else upgrade database from 10.2.0.1 to 10.2.0.4… Can this be the problem?

      Can I make this object VALID with this:

      SQL>sqlplus / as sysdba
      SQL>drop table plan_table;
      SQL>@?/rdbms/admin/utlxplan
      SQL>@?/rdbms/admin/prvtspao.plb
      SQL>@?/rdbms/admin/utlrp.sql

      Thanks!