• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
I ran p_manage_02 on xxx10. The log file "xxx10_p_manage_02.log" has an error:.
SQL-ALEPH_ADMIN> drop index xxx10.z02_id1.
ERROR at line 1:.
ORA-01418: specified index does not exist..
But now that the job is done, UTIL-A-17-14 shows that the z01_id1 exists and is valid. What should be done to fix this?

Resolution:
There are different scenarios where a job could be trying to drop an index which (correctly) does not exist. (For instance, if a preceding run failed or was canceled.).
As long as it ends up OK, you don't need to worry about it..
If the message occurs in trying to *create* an index, that usually indicates a problem.

• Article last edited: 10/8/2013