Procedure PARTITION_POP_TEMP_LOAD going invalid after sales_data partition
After the table partition on sales_data we are seeing that there is a procedure PARTITION_POP_TEMP_LOAD which became invalid. We could not recompile it as it keeps failing with errors. I see this procedure refers to table PT_SALES_DATA in the system but it does not exist and end up with error when we recompile it. Is there any significance to this procedure?
PFB output:-
OWNER OBJECT_NAME OBJECT_TYPE
-------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------
DEMANTRA12251 PARTITION_POP_TEMP_LOAD PROCEDURE
SQL> alter procedure DEMANTRA12251.PARTITION_POP_TEMP_LOAD compile;
Warning: Procedure altered with compilation errors.
SQL> show errors;