QSM-01024: materialized view, string, has unknown compile errors

QSM-01024: materialized view, string, has unknown compile errors

Cause: Materialized view probably has some metadata errors.

Action: Consider recreating it.

QSM-01023: materialized view, string, has GRANT errors

QSM-01023: materialized view, string, has GRANT errors

Cause: Materialized view probably has some metadata errors.

Action: Consider recreating it.

QSM-01022: a more optimal materialized view than string was used to rewrite

QSM-01022: a more optimal materialized view than string was used to rewrite

Cause: Query Rewrite always chooses the most optimal materialized view based on certain parameters, such as cardinality of the materialized view, number of joins etc. The materialized view specified was found to be less optimal.

Action: To force using a materialized view, consider using a rewrite hint.

QSM-01021: materialized view, string, not found in the hint list

QSM-01021: materialized view, string, not found in the hint list

Cause: There is a rewrite hint list specified in the query, but this materialized view is not among the hinted ones.

Action: Include this materialized view in the rewrite hint list.

QSM-01020: materialized view, string, is ineligible

QSM-01020: materialized view, string, is ineligible

Cause: Materialized view is probably disabled or stale.

Action: Consider enabling the materialized view for rewrite or refreshing it.

QSM-01019: no suitable materialized view found to rewrite this query

QSM-01019: no suitable materialized view found to rewrite this query

Cause: There doesn t exist any materialized view in the dataware house that can be used to rewrite this query.

Action: Consider creating a new materialized view.

QSM-01018: single table materialized join view rewrite not required

QSM-01018: single table materialized join view rewrite not required

Cause: Materialized join view is more expensive for rewrite than using the base table

Action: none.

QSM-01017: aggregate argument cannot be converted to canonical form

QSM-01017: aggregate argument cannot be converted to canonical form

Cause: Argument of each aggregrate in the query needs to be convertible into a canonical form for query rewrite.

Action: none

QSM-01016: Query rewrite does not support, aggregate, string

QSM-01016: Query rewrite does not support, aggregate, string

Cause: No query rewrite, if the query contains any DISTINCT aggregates other than COUNT, MIN or MAX.

Action: none

QSM-01015: GROUP BY clause has non-columns

QSM-01015: GROUP BY clause has non-columns

Cause: No query rewrite, if there is no valid column in the GROUP BY clause.

Action: none

QSM-01014: top level operator in WHERE clause of the query is an OR

QSM-01014: top level operator in WHERE clause of the query is an OR

Cause: If the top-level operator in the WHERE clause is an OR and there is more than one table in the FROM list, then query rewrite will not take place.

Action: none

QSM-01013: nested aggregates or CONNECT BY or START WITH clause present

QSM-01013: nested aggregates or CONNECT BY or START WITH clause present

Cause: If the query contains nested aggregates, CONNECT BY clause, or START WITH clause, query rewrite will not take place

Action: none

QSM-01012: SAMPLE clause present in FROM

QSM-01012: SAMPLE clause present in FROM

Cause: If a query contains a SAMPLE clause, query rewrite will not take place

Action: none

QSM-01011: when heuristic rewrite not set, rewrite hint required

QSM-01011: when heuristic rewrite not set, rewrite hint required

Cause: When using a stored outline, a rewrite hint is required for query rewrite

Action: none

QSM-01010: table(s) in the query not found in materialized view, string

QSM-01010: table(s) in the query not found in materialized view, string

Cause: If the materialized view does not reference the base tables found in the query, it cannot be used for rewrite

Action: none

QSM-01009: query rewritten with materialized view, string, using text match algorithm

QSM-01009: query rewritten with materialized view, string, using text match algorithm

Cause: The query was rewritten using a materialized view, because query text matched the definition of the materialized view

Action: none

QSM-01008: no query rewrite for update queries

QSM-01008: no query rewrite for update queries

Cause: If a query or part of it has any DML update operations, no query rewrite will take place.

Action: none

QSM-01007: query has NOREWRITE hint

QSM-01007: query has NOREWRITE hint

Cause: When query contains a NOREWRITE hint, no query rewrite will take place for that query block.

Action: Remove the NOREWRITE hint from the query

QSM-01006: query rewrite disabled for this query block

QSM-01006: query rewrite disabled for this query block

Cause: During query rewrite, certain view query blocks cannot be rewritten.

Action: none

QSM-01005: no query rewrite when query has slave SQL

QSM-01005: no query rewrite when query has slave SQL

Cause: Current prcess is a kxfx slave

Action: none

QSM-01004: no query rewrite before view merging

QSM-01004: no query rewrite before view merging

Cause: Internal session parameter _QUERY_REWRITE_2 is set to FALSE

Action: Change session parameter with ALTER SESSION command.

QSM-01003: no query rewrite on DDL queries

QSM-01003: no query rewrite on DDL queries

Cause: If query contains any data definition operations, no query rewrite will take place.

Action: none.

QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

Cause: Query rewrite did not occur because the OPTIMIZER_MODE was set to RULE.

Action: Change the optimizer mode using the OPTIMIZER_MODE parameter.

QSM-01001: query rewrite not enabled

QSM-01001: query rewrite not enabled

Cause: When query rewrite is disabled, no query rewrite will take place.

Action: Enable query rewrite with ALTER SESSION SET QUERY_REWRITE ENABLE command.

QSM-00999: Advisor feature is not currently implemented

QSM-00999: Advisor feature is not currently implemented

Cause: The user attempted to execute an unsupported advisor operation.

Action: Verify the availability of the operation.

QSM-00806: The string parameter value must be specified when STORAGE_MODE is set to TOTAL

QSM-00806: The string parameter value must be specified when STORAGE_MODE is set to TOTAL

Cause: While performing EXECUTE_TASK, the user specified a STORAGE_ MODE of TOTAL, but failed to set the DEF_MVIEW_OWNER and DEF_INDEX_ OWNER to valid owner names.

Action: Set the specified owner to a valid name

QSM-00805: the specified recommendation string value string is invalid

QSM-00805: the specified recommendation string value string is invalid

Cause: The user has specified an invalid value when attempting to change a recommendation attribute.

Action: Adjust the target attribute value and retry the operation.

QSM-00804: not enough space for mandatory access structures

QSM-00804: not enough space for mandatory access structures

Cause: While performing EXECUTE_TASK, the user specified a STORAGE_ CHANGE value that leaves no space for mandatory access structures, such as primary key indexes.

Action: Set a greater STROAGE_CHANGE value.

QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.

QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.

Cause: While performing EXECUTE_TASK, the user specified a STORAGE_ CHANGE value that is incompatible with the type of workload data.

Action: Set a positive STORAGE_CHANGE value.

QSM-00802: An error occurred while implementing action string (string) string.

QSM-00802: An error occurred while implementing action string (string) string.

Cause: While performing IMPLEMENT_TASK, a specific action operation failed.

Action: Make the necessary adjustments as specified in the secondary message and retry the operation.

QSM-00801: the specified username string is invalid

QSM-00801: the specified username string is invalid

Cause: The user has specified an invalid username.

Action: Adjust the target username and retry the operation.

QSM-00800: the specified workload name string is invalid

QSM-00800: the specified workload name string is invalid

Cause: The user has specified an invalid workload name.

Action: Adjust the target workload name and retry the operation.

QSM-00799: the user-defined workload table string cannot be found

QSM-00799: the user-defined workload table string cannot be found

Cause: The user has attempted to import a workload from an external table that does not exist or cannot be accessed.

Action: Adjust the target workload table and retry the operation.

QSM-00798: the specified workload string already exists

QSM-00798: the specified workload string already exists

Cause: The user attempted to create the specified workload using a name that already exists in the Advisor repository. Task names must be unique to the database user.

Action: Adjust the name and retry the operation.

QSM-00797: the specified workload string does not exist for the current user

QSM-00797: the specified workload string does not exist for the current user

Cause: The user attempted to reference an Access Advisor workload using a name that does not exist in the Advisor repository.

Action: Adjust the name and retry the operation.

QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

Cause: The user attempted to add a workload statement that references a table with missing statistics.

Action: Gather statistics for the referenced table and retry the operation.

QSM-00795: the SQL Tuning Set repository has not been implemented

QSM-00795: the SQL Tuning Set repository has not been implemented

Cause: The user attempted to collect a workload from a SQL Tuning Set repository that has not yet been implemented or enabled.

Action: Validate the existence of the repository and retry the operation.

QSM-00794: the statement can not be stored due to a violation of the string filter

QSM-00794: the statement can not be stored due to a violation of the string filter

Cause: The user attempted to manually add a workload statement that failed a filter test. Manual statements must meet the same filtering guidelines as imported statements.

Action: Adjust the attributes or the filter and retry the operation.

QSM-00793: the specified SQL Tuning Set string does not exist

QSM-00793: the specified SQL Tuning Set string does not exist

Cause: The user specified a SQL Tuning Set that has not been defined in the SQL Tuning Set repository.

Action: Correct the SQL Tuning Set name and retry the operation.

QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

Cause: The user attempted to add a workload statement that contains a table without statistics. Access Advisor requires all referenced tables to have valid statistics.

Action: Validate the workload statement and retry the operation.

QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

QSM-00791: the specified SQL statement cannot be stored in the workload because is contains unsupported statement type

Cause: The user attempted to add a workload statement that contains an invalid statement type. Supported statement types are INSERT, DELETE, UPDATE, SELECT and MERGE.

Action: Validate the workload statement and retry the operation.

QSM-00790: the workload string cannot be modified or changed because it is being used by task string

QSM-00790: the workload string cannot be modified or changed because it is being used by task string

Cause: The user attempted to change or delete a workload that is referenced by an active task.

Action: Remove references to a workload from any tasks that reference that workload, unless the task is in its initial task state.

QSM-00789: the string string is invalid for directive string

QSM-00789: the string string is invalid for directive string

Cause: The user attempted to add a directive that contains an empty or invalid attribute.

Action: Correct the value and retry the operation.

QSM-00788: the table string is invalid for directive string

QSM-00788: the table string is invalid for directive string

Cause: The user attempted to add a directive that contains an empty or invalid table specification.

Action: Correct the name and retry the operation.

QSM-00787: the tablespace string is invalid for directive string

QSM-00787: the tablespace string is invalid for directive string

Cause: The user attempted to add a directive that contains an empty or invalid tablespace name.

Action: Correct the name and retry the operation.

QSM-00786: the name string is invalid for directive string

QSM-00786: the name string is invalid for directive string

Cause: The user attempted to add a directive that contains an empty or invalid object name.

Action: Correct the name and retry the operation.

QSM-00785: the directive string is not supported for task string at this time

QSM-00785: the directive string is not supported for task string at this time

Cause: The user attempted to add an invalid directive to the current task.

Action: Validate the directive and retry the operation.

QSM-00784: the string string referenced in the list string is invalid for parameter string

QSM-00784: the string string referenced in the list string is invalid for parameter string

Cause: The user attempted to set a task parameter using an invalid username or table specification.

Action: Validate the object name and retry the operation.

QSM-00783: the specified value string contains an invalid date for parameter string

QSM-00783: the specified value string contains an invalid date for parameter string

Cause: The user attempted to set a task parameter using invalid date formatting.

Action: A date literal must be in the form DD or MM or YYYY HH24:MI:SS.

QSM-00782: the specified value string is an invalid date format for parameter string

QSM-00782: the specified value string is an invalid date format for parameter string

Cause: The user attempted to set a task parameter using invalid date formatting directives.

Action: See the Oracle documentation for valid date-formatting and retry the operation.

QSM-00781: the specified value string is invalid for parameter string. Valid keywords are string

QSM-00781: the specified value string is invalid for parameter string. Valid keywords are string

Cause: The user attempted to set a task parameter using invalid data.

Action: Adjust the data value and retry the operation

QSM-00780: the task string could not be executed because the workload string is being modified

QSM-00780: the task string could not be executed because the workload string is being modified

Cause: While attempting to execute a task, Access Advisor checks for exclusive access to all of the referenced workloads. If any cannot be reserved, then the execution fails.

Action: Wait until the referenced workloads are free for exclusive access retry the operation.

QSM-00779: the specified directive conflicts with the existing directive string

QSM-00779: the specified directive conflicts with the existing directive string

Cause: The user attempted to add a directive that cannot operate with an existing directive.

Action: Check the advisor documentation for valid directives.

QSM-00778: the specified output filename string is invalid or cannot be accessed

QSM-00778: the specified output filename string is invalid or cannot be accessed

Cause: The user attempted to create a report or script in a file that cannot be written or created.

Action: Adjust the file name or directory and retry the operation.

QSM-00777: the specified directive string is unsupported at this time

QSM-00777: the specified directive string is unsupported at this time

Cause: The user attempted to create a directive that is not currently supported.

Action: Check the advisor documentation for valid directives.

QSM-00776: the user-defined workload string is missing the following column: string

QSM-00776: the user-defined workload string is missing the following column: string

Cause: The user attempted to import a workload from an external table; however, the table does not contain all of the required columns.

Action: Adjust the target workload table and retry the operation.

QSM-00775: the specified SQL statement cannot be stored in the workload due to invalid table references

QSM-00775: the specified SQL statement cannot be stored in the workload due to invalid table references

Cause: The user attempted to add a workload statement that contains one or more invalid identifier for the parsing user.

Action: Validate the workload statement and retry the operation.

QSM-00774: there are no SQL statements to process for task string

QSM-00774: there are no SQL statements to process for task string

Cause: While executing, the specified task found no valid SQL statements to analyze. Possible causes are: an empty workload, table filtering, or username filtering.

Action: Validate the workload and the appropriate task parameters and retry the operation.

QSM-00773: the parameter string contains the invalid string name string

QSM-00773: the parameter string contains the invalid string name string

Cause: The task or workload parameter contains a name that is either too long or does not exist in the database.

Action: Validate the parameter value and retry the operation.

QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error

QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error

Cause: The user attempted to add a workload statement that contains invalid SQL syntax or an invalid column reference.

Action: Validate the workload statement and retry the operation.