ORA-19390: The profile type is not valid Database version: Oracle 11g Release 2 (11.2) Cause: The profile type is not valid. Solution: Check the available profile types.  Read More →

ORA-19389: LOB types are not supported for SQL binds Database version: Oracle 11g Release 2 (11.2) Cause: A LOB type was provided in a SQL bind list. Solution: Replace the LOB binds with legal bind types or try another SQL.  Read More →

ORA-19388: operation not supported for “SQL Tuning Set” type Database version: Oracle 11g Release 2 (11.2) Cause: The attempted operation was unsupported for the type of the given SQL Tuning Set. Solution: Check the SQL Tuning Set and retry the operation.  Read More →

ORA-19387: “SQL Tuning Set” “string” belongs to another tuning task Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to tune a task-managed SQL Tuning Set belonging to one task within the scope of another task. Solution: Check the SQL Tuning Set and retry the operation.  Read More →

ORA-19386: target object already exists for tuning task “string” Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to set a target object for a tuning task when one had already been set. Solution: Create a new task if another target object is needed.  Read More →

ORA-19385: staging table is empty Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to perform an operation on an empty staging table. Solution: Check the staging table to make sure that it has rows.  Read More →

ORA-19384: cannot pack into staging table from previous version Database version: Oracle 11g Release 2 (11.2) Cause: An attempt was made to perform a pack operation on a staging table from a previous version. Solution: Create a staging table in the current version and retry the operation.  Read More →

ORA-19381: cannot create staging table in SYS schema Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to create a staging table in the sys schema Solution: Create the table in another schema.  Read More →

ORA-19380: invalid plan filter Database version: Oracle 11g Release 2 (11.2) Cause: The user specified an invalid filter for the plan when calling the select_sqlset table function. Solution: Adjust the the filter to be one of the following values and retry the operation: MAX_ELAPSED_TIME, MAX_CPU_TIME, MAX_DISK_READS, MAX_OPTIMIZER_COST, MAX_BUFFER_GETS, FIRST_LOADED LAST_LOADED, FIRST_GENERATED,... 

ORA-19379: invalid time_limit or repeat_interval Database version: Oracle 11g Release 2 (11.2) Cause: The user specified a NULL value for either the time_limit or the repeat_interval, or a repeat_interval that is greater than the time_limit Solution: Provide a non-null value and make sure time_limit >= repeat_interval  Read More →

ORA-19378: invalid mode Database version: Oracle 11g Release 2 (11.2) Cause: The user specified an invalid mode argument to the capture function. Solution: Provide a mode argument that was defined in the dbmssqlt file  Read More →

ORA-19377: no “SQL Tuning Set” with name like “string” exists for owner like “string” Database version: Oracle 11g Release 2 (11.2) Cause: The user specified a filter to a pack/unpack function for the SQL Tuning Set that targets no STS in the SYS schema or the staging table, respectively Solution: Provide a different filter after checking the state of the...