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... 

ORA-19376: no privileges on tablespace provided or tablespace is offline Database version: Oracle 11g Release 2 (11.2) Cause: The user tried to create a staging table on a tablespace on which he does not have any space allocated, or it is offline Solution: Allocate space on the tablespace, bring it online, and retry  Read More →

ORA-19375: no CREATE TABLE privilege on schema “string” Database version: Oracle 11g Release 2 (11.2) Cause: The user tried to create a staging table when he is missing the CREATE TABLE privilege on the specified schema. Solution: Grant the privilege to the user and retry  Read More →

ORA-19374: invalid staging table Database version: Oracle 11g Release 2 (11.2) Cause: The user specified an invalid staging table to one of the pack, unpack, or remap stgtab routines, or the user does not have the correct privileges on the staging table Solution: Provide a correct staging table or grant the appropriate privileges  Read More →

ORA-19373: invalid staging table or tablespace Database version: Oracle 11g Release 2 (11.2) Cause: The user attempted to create a staging table and specified an invalid staging table (or one that already exists) or tablespace Solution: Check the arguments and try again.  Read More →