Object sys.DBMS_SQLPA package is invalid.
Posted on 2014-02-21
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
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 ?