joe_echavarria
asked on
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.sq l
@?/rdbms/admin/prvtspao.pl b
@?/rdbms/admin/utlrp.sql
select OWNER,object_name,object_t ype 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,
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.sq
@?/rdbms/admin/prvtspao.pl
@?/rdbms/admin/utlrp.sql
select OWNER,object_name,object_t
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER