Oracle Database Errors or Warnings from Error ORA-13779 to ORA-13788

SQLServerF1

ORA-13779: invalid load option
Cause: The user attempted to call load_sqlset with a load option that is different than INSERT, UPDATE and MERGE.
Action: Adjust the load option and retry the operation.
ORA-13780: SQL statement does not exist.
Cause: The user attempted to tune a SQL statement that does not exist.
Action: Verify the sql_id and the plan hash value of the statement and retry the operation.
ORA-13781: cannot perform test-execute and explain plan operations on the automatic SQL tuning task
Cause: The user attempted to test-execute or generate explain plans for a SQL workload using the automatic SQL tuning task.
Action: Verify the name of the tuning task and retry the operation.

ORA-13783: invalid tuning scope
Cause: The user attempted to specify a tuning task scope that is invalid. The possible values are LIMITED or COMPREHENSIVE.
Action: Check the scope value and retry the operation.
ORA-13784: cannot accept SQL profiles for all statements in the “string”
Cause: An attempt was made to accept SQL profiles for all statements in the input workload.
Action: Provide the object identifier corresponding to a statement in the workload and retry the operation.
ORA-13785: missing target object for tuning task “string”
Cause: The user attempted to perform an operation on a task without specifying a target object or by using an invalid object identifier.
Action: Check the identifier of the object and retry the operation.

ORA-13786: missing SQL text of statement object “string” for tuning task “string”
Cause: The user attempted to accept SQL profile for an object that has not a SQL text associated to it.
Action: Check the identifier of the object and retry the operation.
ORA-13787: missing SQL profile for statement object “string” for tuning task “string”
Cause: The user attempted to accept a SQL profile for an object that has not a SQL profile associated to it.
Action: Check the identifier of the object and retry the operation.
ORA-13788: invalid recommendation type
Cause: 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.
Action: Check the rec_type arg and retry the operation.

Above are list of Oracle Database Errors or Warnings from Error ORA-13779 to ORA-13788 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *