# ORA-32010: cannot find entry to delete in SPFILE

## ORA-32010: cannot find entry to delete in SPFILE

Error
Reset the parameter in Oracle Database, we are getting the following error during resetting.
``` SQL> ALTER SYSTEM RESET "_optimizer_enable_extended_stats"; ALTER SYSTEM RESET "_optimizer_enable_extended_stats" * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE ```

Cause:
Reset command delete the parameter from the SPFILE. So parameter is not available in SPFILE.

Solution
Check the parameter is present or not by creating PFILE.
``` Create PFILE='E:\init.txt' from spfile; ```

This entry was posted in Oracle on .