Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

Object sys.DBMS_SQLPA package is invalid.

Hi,

  The current object is invalid.  

   SYS      DBMS_SQLPA      PACKAGE BODY      INVALID


  What is the procedure to make it invalid ?, i been searching the internet and i have found the below procedure to fix it.


drop table plan_table
@?/rdbms/admin/utlxplan.sql
@?/rdbms/admin/prvtspao.plb
@?/rdbms/admin/utlrp.sql


select OWNER,object_name,object_type from dba_objects where object_name='PLAN_TABLE';

SYS      PLAN_TABLE      TABLE
PUBLIC      PLAN_TABLE      SYNONYM
SYSTEM      PLAN_TABLE      TABLE


What would be the table to be dropped ?

Is that the correct way to fix this error ?

Regards,
0
joe_echavarria
Asked:
joe_echavarria
1 Solution
 
slightwv (䄆 Netminder) Commented:
Have you manually tried to recompile it?  Objects become invalid all the time.

A manual recompile should also allow you to see the errors generated if it fails to recompile.

>>Is that the correct way to fix this error ?

@?/rdbms/admin/utlrp.sql will recompile all objects in dependency order so I would first start with this.

It can take a while to run so be patient.

>>What would be the table to be dropped ?

What table?
0
 
joe_echavarriaDatabase AdministratorAuthor Commented:
I just needed to recompile it.  Is not invalid now.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now