How to fix the Oracle error ORA-13788: invalid recommendation type?

In this post, you’ll learn more about the Oracle ErrorORA-13788: invalid recommendation type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13788: invalid recommendation type

Reason for the Error ORA-13788: invalid recommendation type

The user passed an invalid recommendation type in the rec_type argument to script_tuning_task. Possible values are ALL or any subset of a comma-separated list of PROFILES, STATISTICS and INDEXES.

How to fix the Error ORA-13788: invalid recommendation type ?

You can fix this error in Oracle by following the below steps

Check the rec_type arg and retry the operation.