Skip Headers
Oracle® Database Error Messages
10g Release 2 (10.2)

Part Number A14219-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
 

31 QSM-00501 to QSM-03120

QSM-00501: unable to initialize Summary Advisor environment
Cause: The Summary Advisor external procedure initialization process failed.
Action: Contact Oracle Worldwide Support.
QSM-00502: OCI error
Cause: A OCI callback routine reported an error
Action: Contact Oracle Worldwide Support.
QSM-00503: out of memory
Cause: Summary Advisor failed to allocate the necessary memory.
Action: Contact Oracle Worldwide Support.
QSM-00504: internal error
Cause: An internal error occurred.
Action: Contact Oracle Worldwide Support.
QSM-00505: syntax error
Cause: A syntax error occurred.
Action: Correct syntax error if possible or contact Oracle Worldwide Support.
QSM-00506: no fact-tables could be found
Cause: The fact-filter is not specified, and there are no fact-tables in the warehouse. A fact-table is a table having foreign-key constraints to one or more of the dimension-tables in the data warehouse.
Action: Check the fact-filter is correctly specified; check that appropriate constraints exist; and the user has privileges to access the tables
QSM-00507: no dimensions could be found
Cause: The database does not have any dimensions
Action: Create the dimensions in your warehouse
QSM-00508: statistics missing on tables/columns
Cause: The system metadata does not contain statistics on one or more tables or columns. The Advisor needs cardinalities of all fact-tables, and of the level-keys of all dimensions in the data warehouse.
Action: Run ANALYZE on the tables and summaries in the warehouse to collect statistics
QSM-00509: invalid parameter
Cause: The indicated parameter has an invalid value
Action: Supply a value in the proper range
QSM-00510: statistics missing on materialized views
Cause: The system metadata does not contain statistics on one or more materialized views. The Advisor needs cardinalities of all materialized views in the data warehouse.
Action: Run ANALYZE on the tables and materialized views in the warehouse to collect statistics.
QSM-00511: invalid fact-tables specified in fact-filter
Cause: The tables specified in the fact-filter are not valid fact-tables. A fact-table must have foreign-key constraints to one or more of the dimension-tables in the data warehouse.
Action: Check the fact-filter is correctly specified; check that appropriate constraints exist; and the user has privileges to access the tables
QSM-00512: invalid summaries specified in the retention-list
Cause: The summaries specified in the retention-list are not valid.
Action: Check the spelling of the summary-names; check that they are valid; and the user has privileges to access them.
QSM-00513: one or more of the workload tables is missing
Cause: One or both of the workload tables are missing. The two workload tables which should be present in the user"s schema are V_192216243_F_5_E_14_8_1 and V_192216243_F_5_E_15_8_1; the former is mapped to WORK$_IDEAL_MVIEW and the latter to WORK$_MVIEW_USAGE. The workload tables are created by the Oracle Trace Formatter when the data-collection-file (oraclesm.dat) is formatted by the user.
Action: Check whether the Formatter succeeded in formatting the data collection. Sometimes the V_192216243_F_5_E_14_8_1 (i.e WORK$_IDEAL_MVIEW) may not be created whereas the other table is created. The most likely cause of this is the init.ora parameters needed to invoke mview-rewrite are not enabled. Check your documentation for all the init.ora parameters which need to be set for mview-rewrite to occur. Another possibility is no GROUP BY queries were issued during the time the data was collected, in which case, run the Trace collection for a longer time to get a representative sampling of the queries issued in the data warehouse.
QSM-00514: the size of must-retain summaries exceeds specified space limit
Cause: The specified space limit is greater than the size of must-retain summaries.
Action: Reduce the number of must-retain summaries or increase the space limit
QSM-00515: operation cancelled by user
Cause: The operation has been cancelled by the user
Action: None
QSM-00516: illegal status detected for run
Cause: The run has encountered an illegal value in the status field of the mview$_adv_log table. This could be internal error or an application error.
Action: Contact Oracle Worldwide Support.
QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater
Cause: The current database has a compatibility setting that is earlier than the supported server version.
Action: Adjust the instance parameter COMPATIBLE to 8.1.0.0 or greater.
QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL
Cause: The current database has has not be created or upgraded to support Java stored procedures. Summary Advisor requires Java stored procedures.
Action: Log into the database with SYSDBA privileges. Execute the INITJVM.SQL script which is found in the ORACLE home directory under JAVAVM. Next, execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home.
QSM-00519: Summary Advisor is not installed. Please execute INITQSMA.SQL.
Cause: The current database has has not be created or upgraded to support Summary Advisor. Summary Advisor requires several Java stored procedures.
Action: Log into the database with SYSDBA privileges. Execute the INITQSMA.SQL script found in the ADMIN directory under the ORACLE home. **** **** Messages 520-700 are in the 9i Summary Advisor Java modules 701-708 are Hypothetical Workload generator journal messages
QSM-00710: data access error in module string
Cause: SQL Access Advisor detected a severe error while accessing the advisor repository.
Action: See the accompanying error message for approprate actions.
QSM-00750: the specified value string for parameter string is invalid or contains an invalid item
Cause: The user attempted to set a task parameter using invalid data.
Action: Adjust the data value and retry the operation.
QSM-00751: the file string could not be opened for write access
Cause: Access Advisor could not create the script or report due to a file system error.
Action: Verify the location for file write access and retry the operation.
QSM-00752: the parameter string contains an invalid combination of options string
Cause: The user specified correct option keywords, but entered a combination that is not supported within Access Advisor.
Action: Validate the correct option usage and retry the operation.
QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string
Cause: The user attempted to set a task parameter using invalid data.
Action: Adjust the data value and retry the operation.
QSM-00754: task string does not reference a valid workload and therefore cannot be executed
Cause: The user attempted to execute a advisor task that requires a workload.
Action: Specify a workload for the task and retry the operation.
QSM-00755: a set of workload statements already exists for workload string
Cause: The user attempted to save workload data into an existing workload that already contains data without specifying APPEND or REPLACE.
Action: Validate the import mode retry the operation.
QSM-00756: the specified workload string is being used by one or more advisor tasks
Cause: The user attempted to modify or delete a workload that is currently being used by another task.
Action: Remove the workload reference from the advisor task and retry the operation.
QSM-00757: the specified workload string is not referenced by task string
Cause: The user attempted to delete invalid workload reference from the task.
Action: Validate the workload reference and retry the operation.
QSM-00758: the specified parameter string is not valid for workload string
Cause: The user attempted to access a workload parameter that is does not exist for the specified workload. The parameter may be misspelled or the user selected a parameter that is not supported by the particular advisor.
Action: Validate the parameter name and retry the operation.
QSM-00759: the user string does not exist for the specified workload statement
Cause: The user attempted to add a new SQL statement with an invalid username.
Action: Adjust the name and retry the operation.
QSM-00760: the import mode string is invalid for the current operation
Cause: The user attempted to store data in the repository with an invalid import mode.
Action: Use one of the following valid values: NEW, APPEND, or REPLACE.
QSM-00761: the priority string is invalid for the current operation
Cause: The user attempted to store data in the repository with an invalid priority.
Action: Use one of the following valid values: 1, 2, 3.
QSM-00762: the specified Summary Advisor workload string does not exist
Cause: The user attempted to import an advisor workload from an invalid or non-existent Summary Advisor workload.
Action: Validate the Summary Advisor workload identifier and retry the operation.
QSM-00763: the owner string was not found while validating user-defined workload string.string
Cause: The user attempted to import an advisor workload from a user who may not access to the table.
Action: Validate the location of the user-defined workload.
QSM-00764: the column string was not found in the user-defined workload table string.string
Cause: The user attempted to import an advisor workload from a user table that does not contain the required column.
Action: Validate the user-defined workload table and retry the operation.
QSM-00765: cannot validate user-defined workload because table string.string is invalid.
Cause: The user attempted to import an advisor workload from a table that is not accessible.
Action: Validate the location of the user-defined workload.
QSM-00766: a SQL statement is required for the current workload operation
Cause: The user attempted to create an entry in a workload collection without specifying a SQL statement.
Action: Validate the SQL statement and retry the operation.
QSM-00767: a SQL cache is not available to user string
Cause: The user attempted to collect a workload from the SQL without having authorization.
Action: Validate the user account and retry the operation.
QSM-00768: the search condition is invalid for the requested operation
Cause: The user provided a invalid SEARCH argument to an Access Advisor workload operation. A search condition must be a valid SQL search condition using only the column names specified in the procedure documentation.
Action: Correct the search condition and retry the operation.
QSM-00769: the SQL statement string was not found for workload string
Cause: The user attempted to access a SQL statement that does not exist in the workload.
Action: Validate the SQL statement identifier and retry the operation.
QSM-00770: the specified workload string is already referenced by task string
Cause: The user attempted to add a workload reference to a task when the task already contains the reference.
Action: Validate the workload reference and retry the operation.
QSM-00771: the specified SQL statement cannot be stored in the workload because it has no valid table references
Cause: The user attempted to add a workload statement that contains table references that are either system-specified or user-specified invalid tables.
Action: Validate the workload statement and retry the operation.
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.
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-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-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-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-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-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-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-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-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-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-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/MM/YYYY HH24:MI:SS.
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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-01003: no query rewrite on DDL queries
Cause: If query contains any data definition operations, no query rewrite will take place.
Action: none.
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-01005: no query rewrite when query has slave SQL
Cause: Current prcess is a kxfx slave
Action: none
QSM-01006: query rewrite disabled for this query block
Cause: During query rewrite, certain view query blocks cannot be rewritten.
Action: none
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-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-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-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-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-01012: SAMPLE clause present in FROM
Cause: If a query contains a SAMPLE clause, query rewrite will not take place
Action: none
QSM-01013: nested aggregates or CONNECT BY/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-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-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-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-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-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-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-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-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-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-01023: materialized view, string, has GRANT errors
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01024: materialized view, string, has unknown compile errors
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01025: materialized view, string, not found
Cause: The specified materialized view is not found in the database.
Action: Check the spelling or create a new materialized view
QSM-01026: query rewrite is disabled for, string
Cause: Query rewrite could not use this materialized view, because query rewrite was not enabled for it.
Action: Enable query rewrite for the materialized view with ALTER MATERIALIZED VIEW "mv" ENABLE QUERY REWRITE command, where "mv" is the name of the materializev view.
QSM-01027: materialized view, string, is unusable
Cause: Materialized view probably has some metadata errors.
Action: Consider recreating it.
QSM-01028: materialized view, string, is currently being refreshed
Cause: Materialized view cannot be used for query rewrite while it is being refreshed
Action: Rerun the query, after the refresh operation is completed.
QSM-01029: materialized view, string, is stale in ENFORCED integrity mode
Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to ENFORCED.
Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.
QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode
Cause: A materialized view with PL/SQL functions in its definition cannot be used for query rewrite when query rewrite integrity is set to ENFORCED.
Action: Consider running the query in STALE TOLERATED mode.
QSM-01031: materialized view, string, is stale in TRUSTED integrity mode
Cause: A stale materialized view cannot be used for query rewrite when the query rewrite integrity mode is set to TRUSTED.
Action: Refresh the materialized view or alter the rewrite integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY = STALE TOLERATED command.
QSM-01032: materialized view, string, not found
Cause: There was no associated metadata for the materialized view.
Action: Check the spelling and re-run the query.
QSM-01033: query rewritten with materialized view, string
Cause: The specified materialized view was used to rewrite the given query.
Action: none
QSM-01034: materialized view, string, needs a dimension level to join table, string
Cause: One or more hierarchical relationship(s) in the table(s) could not be established.
Action: Consider adding a level in the dimension to provide the missing intra- table relationships.
QSM-01035: a row level security policy exists on this table
Cause: Any row level security policy that may exist on a base-table prevents exact text match query rewrite.
Action: none.
QSM-01036: unmatched column, string, present in query after view merging
Cause: Clearing the columns after view merging failed due to some reasons - bug??
Action: none
QSM-01037: Query Rewrite failed to allocate the necessary query join graph
Cause: Join graph allocation and initialization failed, possibly due to one or more undetermined operand(s) in the query expression.
Action: none
QSM-01038: logical operator(s) could not be processed
Cause: One or more logical operator(s) in the query predicates could not be processed, possibly due to invalid operator(s).
Action: none
QSM-01039: selection present on right hand side of an outer join
Cause: Query cannot be rewritten if any predicate contains a selection on the right hand side of an outer join.
Action: none
QSM-01040: match between the materialized view (string) and query join graphs failed
Cause: Query rewrite will not take place if the joins in the query and the materialized view do not have any match.
Action: none
QSM-01041: materialized view, string, does not match with a measure in the query
Cause: If a measure (such as SUM, AVERAGE) in the query cannot be matched or computed from the materialized view, it will not be used for rewrite.
Action: none
QSM-01042: anchor and matching join arc check failed for string
Cause: If there is a lossy join in the materialized view that doesn"t exist in the query, query rewrite will not take place.
Action: none
QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string
Cause: Query Rewrite will not occur if a join back is required to a table that appears to the right hand side of a semi or anti-join.
Action: none
QSM-01044: join back attempted on a view for string
Cause: Query Rewrite will not occur if a join back to a table is required to find any missing columns.
Action: none
QSM-01046: complex join back on correlated columns not allowed (string)
Cause: Query Rewrite will not occur if a join back is required on a column that is referenced by a sub-query.
Action: none
QSM-01047: complex join back on non-MAV rewrite not allowed (string)
Cause: Query Rewrite can occur by means of a complex join back only during a MAV rewrite.
Action: none
QSM-01048: join back level(s) not present (string)
Cause: Query Rewrite requires joining back to a level of a dimension to find a missing information.
Action: Consider creating a dimension.
QSM-01049: semi-join check failed for materialized view, string
Cause: If there is a semi join in the query, then Query Rewrite will create (select distinct <pk-list>, <ref-col> from mjv) where <pk-list> is the list of rowids/pk of all mjv tables that don"t correspond to a right side of a semi-join and <ref-col> are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action: none
QSM-01050: roll-up check failed for materialized view, string
Cause: A column in the query cannot be computed from the materialized view.
Action: Consider creating a dimension to supply the missing information
QSM-01051: no support for rollup when a window function is present on the column
Cause: No query rewrite if a window function is present on a column that requires a roll-up to compute a measure.
Action: none
QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode
Cause: A join present in the materialized view requires validated primary/foreign key constraints in ENFORCED query rewrite integrity mode.
Action: Validate the constraint or change the integrity mode with ALTER SESSION SET QUERY_REWRITE_INTEGRITY = STALE_TOLERATED command.
QSM-01053: NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode
Cause: A join present in the materialized view requires RELY mode to be set on the primary/foreign key constraints.
Action: Set the RELY mode with ALTER TABLE <table> MODIFY CONSTRAINT <constraint> RELY command. Alternatively validate the constraint with ALTER TABLE <table> VALIDATE CONSTRAINT <constraint>.
QSM-01054: no join match between query and summary, string
Cause: There are no common joins between the query and the the materialized view
Action: none
QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph
Cause: Join graph allocation and initialization failed, possibly due to one or more undetermined operand(s).
Action: none
QSM-01056: no query rewrite for this DDL expression
Cause: Some SELECT statements which are part of a DDL expression may be eligible for rewrite. These include CREATE AS SELECT and CREATE OUTLINE statements. The given query expression is a DDL expression, which doesn"t fall in this category.
Action: none
QSM-01057: no query rewrite for this DML expression
Cause: Current DML is being done using an updatable view, so it is not eligible for rewrite.
Action: none
QSM-01058: MV, string, does not have column, string, for a joinback
Cause: A GROUP BY column in the query is not present in the GROUP BY clause of of the materialized view. This usually requires a join back to a third table.
Action: none
QSM-01059: HAVING clause in the query block is malformed
Cause: An illegal HAVING clause has been specified in the query.
Action: Correct the query syntax and run the query again.
QSM-01060: illegal subquery in the HAVING clause
Cause: When a HAVING clause has a subquery, then any references to the tables in the outer query should only reference the tables in the GROUP BY clause.
Action: Correct error in the syntax and rerun the query.
QSM-01061: illegal query expression
Cause: An illegal query was specified. Specifically one of the following criteria was not satisfied: (a) All (non-constant, non-aggregate) SELECT expressions in the query should be made up of group expressions. (b) All column references in the HAVING clause should come from the GROUP BY expressions. (c) If there is an ORDER BY clause, then all column references should come from the GROUP BY or SELECT clause, depending on whether the query selects DISTINCT.
Action: Correct error in the syntax and rerun the query.
QSM-01062: query has one or more manual partition(s)
Cause: Query rewrite is not possible if query has any manual partitions.
Action: none
QSM-01063: query has a dictionary table or view
Cause: Query rewrite is not allowed if query references any dictionary tables/views.
Action: none
QSM-01064: query has a fixed table or view
Cause: Query rewrite is not allowed if query references any fixed tables/views
Action: none
QSM-01065: materialized view, string, cannot compute measure, string, in the query
Cause: If the materialized view cannot compute a measure in the query using the measures in its definition, then query rewrite will not occur.
Action: none
QSM-01066: materialized view, string, does not have the column, string, from query
Cause: Query rewrite will not occur, if the materialized view cannot provide all the columns that the query has
Action: none
QSM-01067: materialized view, string, cannot support the query measure, string
Cause: An attempt was made to push a grouping function through an expression specified in the query to transform a measure. Query rewrite will not occur if this measure transformation failed.
Action: none
QSM-01068: no dimensions present
Cause: An attempt was made to load a dimension from the dataware house, but there were no dimensions present.
Action: none
QSM-01069: summary join graph for, string, does not have table, string
Cause: An attempt to locate an object that is part of a join failed.
Action: none
QSM-01070: equivalence class manager was not found
Cause: An equivalence class manager is required to compute the transitive closure for the columns in an equivalence class.
Action: none
QSM-01071: query rewrite not possible because a join in materialized view % with table % has eliminated some rows found in query
Cause: All lossy joins in the materialized view must be present in the query for query rewrite to occur.
Action: none
QSM-01072: materialized view, string, and query have different joins between tables, string
Cause: Anchors, if any, in the MV and query match. But the joins between these anchors in the MV and query are different.
Action: none
QSM-01073: query rewrite not possible because materialized view, string, has a join not found in query
Cause: Query rewrite may not be possible if the materialized view has some joins that query does not have
Action: none
QSM-01074: query rewrite not possible because materialized view, string, and query have different number of joins between tables, string
Cause: Query rewrite may not be possible if the query has some joins that the materialized view does not have between the same pair of tables.
Action: none
QSM-01075: materialized view, string, does not support aggregate function, string
Cause: The specified aggregate function is not found in the materialized view.
Action: none
QSM-01076: no materialized join view was found
Cause: To support an MJV rewrite, we require a materialized join view.
Action: none
QSM-01077: materialized view, string, is grouping at a higher level than query
Cause: If a query column, which is not present in the materialized view, can be obtained by a rollup within the materialized view, then it should group at a higher level than the materialized view.
Action: none
QSM-01078: materialized view, string, is marked invalid
Cause: The materialized view"s kglobsta field has KGLSINV bit set.
Action: none ??
QSM-01079: DML operation occurred on a table referenced by MV, string
Cause: If any dependent tables of a materialized view undergoes a DML operation, query rewrite may be restricted depending on the query rewrite integrity mode for the session. In this situation, query rewrite will take place only if the rewrite integrity mode is STALE_TOLERATED.
Action: Consider refreshing the materialized view chaning the rewrite integrity mode to STALE_TOLERATED.
QSM-01080: invalid dimension, string
Cause: This dimension table has authorization or compilation problems.
Action: none
QSM-01081: no primary key or row id found for table, string, in MV, string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: none
QSM-01082: Joining materialized view, string, with table, string, not possible
Cause: A column in the query is not found in the summary. To obtain the column, a join back of materialized view to the table by means of either the primary key, foreign key or rowid of the table is required. The specified materialized view does not have the primary key, foreign key or rowid of the table to perform the join operation.
Action: Consider building a dimension-table to provide the missing information.
QSM-01083: query text not available - possible inline view
Cause: During the query rewrite transformation, orignal query was possibly transformed into an inline view.
Action: none
QSM-01084: materialized view string has an anchor table string not found in query
Cause: A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is either lossy or lossless with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Action: none
QSM-01085: materialized view, string, has a lossy join between tables, string
Cause: There are no primary key, foreign key constraints between these tables. But query rewrite is still possible if the lossy join between the above tables also appear in the query
Action: none
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
Cause: Query rewrite does not use dimensions in ENFORCED query rewrite integrity mode. If a suitable dimension is present, consider chaning the current integrity mode to either TRUSTED or STALE_ TOLERATED by using ALTER SESSION SET QUERY_REWRITE_INTEGRITY = command.
Action: none
QSM-01087: query grouping on a column that cannot be derived from materialized view, string
Cause: Query is grouping on undetermined columns.
Action: none
QSM-01089: an inline view in the query does not have a materialized view
Cause: General query rewrite is not possible if an inline view in the query does not have a matching materialized view in the meta data.
Action: none
QSM-01090: no query rewrite after view merging
Cause: Internal session parameter _QUERY_REWRITE_1 is set to FALSE
Action: Change session parameter with ALTER SESSION command.
QSM-01091: cost based optimizer found query rewrite is more expensive
Cause: When cost based optimizer is ON, cost of the rewritten cursor is compared to the cursor generated without query rewrite, and the cheaper one is chosen for execution.
Action: none
QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing
Cause: Materialized join view tries to rewrite a semi-join (IN sub-query) and the primary keys or rowids of left tables of semi-joins are missing from MJV.
Action: none
QSM-01093: anti-join marker not found in materialized join view
Cause: Materialized join view has outer join while the query inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: none
QSM-01094: outer-join filter not found in materialized join view
Cause: Materialized join view has outer join while the query inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: none
QSM-01095: no suitable grouping_id found in MV with grouping sets
Cause: If materialized aggregate view contains grouping sets, then it also must contain the grouping_id() function. This function must contain all columns in the MV GROUP BY.
Action: none
QSM-01096: Materialized view with grouping sets contains duplicates
Cause: Materialized view with grouping sets contains duplicates and no rewrite is supported for it. For example, GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.
Action: none
QSM-01097: Materialized view with grouping sets has too long key
Cause: Materialized view with grouping sets has more that 64 different keys in its GROUP BY. No rewrite is supported then.
Action: none
QSM-01098: mv string clause more restrictive than query string clause
Cause: The materialized view contains a selection condition in the WHERE or HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01099: non-tolerated reference to stale portion of mv for table string
Cause: The materialized view is partially stale. It is stale with respect to one or more partitions in one or more of its detail tables. The request query references one or more such detail partitions.
Action: (1) Change the selection criteria of the request to restrict the query to only the fresh portion of the materialized view, or (2) ALTER {SYSTEM|SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED or (3) refresh the materialized view.
QSM-01100: containment check failed for mv, string
Cause: The materialized view contains a selection condition in the WHERE or HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01101: rollup(s) took place on mv, string
Cause: If query"s GROUP BY has one of the higher levels of columns found in the materialized view, then the lower level columns in the materialized view will be rolled up to compute the desired results.
Action: none
QSM-01102: materialized view, string, requires join back to table, string, on column, string
Cause: A column in the query does not appear in the materialized view. Query rewrite will try to obtain this column from the base table, by doing a join back to that column with the MV.
Action: none
QSM-01103: there is a remote table, string, referenced in the query
Cause: Query rewrite does not support query with remote tables.
Action: none
QSM-01104: query is using flashback
Cause: Query rewrite does not support flashback.
Action: none
QSM-01105: no primary key or row id in MV, string, is found for table, string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: none
QSM-01106: materialized view, string, is stale with respect to some partition(s) in the base table(s)
Cause: Query is requesting some data from the MV that are stale with respect to some partitions in the base tables due to some updates.
Action: refresh the stale partitions and rerun the query
QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed
Cause: Query rewrite is disabled for PCT through a session parameter
Action: none
QSM-01108: maximum number of disjuncts exceeded in the query string
Cause: Query rewrite engine cannot process the query if the number of disjuncts (OR"s)in the WHERE clause exceeds the maximum allowed number. The number of disjuncts in the query and the maximum allowed disjuncts are given at the end of the message in the form of (no of disjuncts in query, maximum disjuncts allowed).
Action: none
QSM-01109: while rewriting with MV, string, table, string, migrated to query delta
Cause: There was an unmatched join on the MV, so a table involved in the join was pushed to the query delta to see if the query can be rewritten
Action: none
QSM-01110: query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query
Cause: All lossy joins in the materialized view must be present in the query for query rewrite to occur.
Action: none
QSM-01111: no partition key or partition marker found in MV, string
Cause: In order to do query rewrite with fresh partitions of an MV, the MV should have a partiton key or partition marker.
Action: none
QSM-01112: WHERE clause of mv, string, is more restrictive than query
Cause: The materialized view contains a selection condition in the WHERE clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01113: HAVING clause of mv, string, is more restrictive than query
Cause: The materialized view contains a selection condition in the HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01115: rollup took place on a column with a window function
Cause: There was a rollup to aggregate the data on a column with a window function.
Action: none
QSM-01116: window function computability checks failed
Cause: The window function in the query could not be computed from the materialized view.
Action: none
QSM-01120: recursive rewrite not allowed here
Cause: This query was possibly rewritten with an equivalence which doesn"t allow further rewrites.
Action: none
QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode
Cause: A stale materialized view created with USING TRUSTED CONSTRAINTS clause cannot be used when the query rewrite integrity mode is set ENFORCED.
Action: Alter materialized view such that it has the ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW <mv> REFRESH USING ENFORCED CONSTRAINTS
QSM-01123: self-join algorithm could not resolve multiple instances
Cause: The generalized self-join algorithm could not resolve the mutliple instances, likely due to mismatch in joins or measures
Action: Consider using aliases in the query to match with the aliases in the materialized view
QSM-01124: set operator materialized view, string, doesn"t have a marker column
Cause: The specified set operator materialized view does not have a marker column.
Action: Add a marker column to the specified materialized view.
QSM-01125: a more optimal set operator materialized view than string was used to rewrite
Cause: Query Rewrite always chooses the most optimal set operator materialized view based on parameters, such as cardinality of the set operator materialized view, number of branches that the set operator materialized view can rewrite etc. The set operator materialized view specified was found to be less optimal.
Action: To force using a set operator materialized view, consider using a rewrite hint.
QSM-01126: query rewritten with set operator materialized view, string
Cause: The specified set operator materialized view was used to rewrite the given query.
Action: none
QSM-01127: query rewritten with materialized view(s), string
Cause: The query was succesfully rewritten with multiple MVs
Action: none
QSM-01128: Multi MV rewrite is disabled
Cause: When multimv query rewrite is disabled, no multimv query rewrite will take place.
Action: Enable multimv query rewrite with ALTER SESSION SET "_MULTIMV_QUERY_REWRITE_ENABLED" = true .
QSM-01129: query has NO_MULTIMV_REWRITE hint
Cause: WHen the query has this hint no multimv rewrite will be tried for this query
Action: Remove hint from query
QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs
Cause: When only multimv query rewrite is enabled, every query block should have at least one MV in it"s from clause
Action: Disable only multimv query rewrite with ALTER SESSION SET "_ONLY_MULTIMV_QUERY_REWRITE_ENABLED" = false .
QSM-01131: query has ONLY_MULTIMV_REWRITE hint
Cause: When the query has this hint no multimv rewrite will be done if the query has a query block with no MVs in the from clause
Action: Remove hint from query
QSM-01132: query has a named array type column
Cause: When the query has a column of named array type, query rewrite cannot be done
Action: none
QSM-01133: query has an ADT column
Cause: When the query has a column of ADT type, query rewrite cannot be done
Action: none
QSM-01134: query has a hidden or nested table column
Cause: When the query has a hidden or nested table column, query rewrite cannot be done
Action: none
QSM-01135: query has an LOB column
Cause: When the query has a column stored in LOB, query rewrite cannot be done
Action: none
QSM-01136: query has a nested table column
Cause: When the query has a nested table column, query rewrite cannot be done
Action: none
QSM-01137: dimension level, string, marked as SKIP WHEN NULL
Cause: Join back is not possible on a level marked as SKIP WHEN NULL in a dimension
Action: none
QSM-01150: query did not rewrite
Cause: See the other messages from explain_rewrite() for explanation"
Action: none
QSM-01168: query rewrite not possible when Fine Grain Auditing is present on a base table
Cause: Query rewrite could not take place because Fine Grain Auditing (FGA) was present on a base table in the query
Action: none
QSM-01169: query rewrite not possible for a CREATE or ALTER VIEW statement
Cause: Query rewrite could not take place because the incoming query was either a CREATE or ALTER VIEW statement
Action: none
QSM-01202: query rewrite not possible when OPTIMIZER_MODE is set to 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-01203: query rewrite not possible on DDL queries
Cause: If query contains any data definition operations, no query rewrite will take place.
Action: none.
QSM-01204: query rewrite not possible before view merging
Cause: Internal session parameter _QUERY_REWRITE_2 is set to FALSE
Action: Change session parameter with ALTER SESSION command.
QSM-01205: query rewrite not possible when query has slave SQL
Cause: Current prcess is a kxfx slave
Action: none
QSM-01207: query rewrite not possible when query has a 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-01208: query rewrite not possible 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-01209: 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-01210: query rewrite not possible because no common table(s) found between materialized view string and query
Cause: If the materialized view does not reference the base tables found in the query, it cannot be used for rewrite
Action: none
QSM-01211: query rewrite not possible when stored outline does not have a rewrite hint
Cause: When using a stored outline, a rewrite hint is required for query rewrite
Action: none
QSM-01212: query rewrite not possible when SAMPLE clause is present in FROM
Cause: If a query contains a SAMPLE clause, query rewrite will not take place
Action: none
QSM-01213: query rewrite not possible when nested aggregates or CONNECT BY/START WITH clause is present
Cause: If the query contains nested aggregates, CONNECT BY clause, or START WITH clause, query rewrite will not take place
Action: none
QSM-01214: query rewrite not possible if OR is the top level operator in query WHERE clause
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-01215: query rewrite not possible when query GROUP BY clause has non-columns
Cause: No query rewrite, if there is no valid column in the GROUP BY clause.
Action: none
QSM-01218: query rewrite is likely more expensive due to a single table match between materialized view and query
Cause: Materialized join view is more expensive for rewrite than using the base table
Action: none.
QSM-01219: no suitable materialized view found to rewrite this query
Cause: There doesn"t exist any materialized view in the database that can be used to rewrite this query.
Action: Consider creating a new materialized view.
QSM-01220: materialized view, string, is disabled, stale or unusable
Cause: Materialized view is probably disabled or stale.
Action: Consider enabling the materialized view for rewrite or refreshing it.
QSM-01222: materialized view string is less optimal than string
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-01241: query measure cannot be derived from the materialized view string
Cause: If a measure (such as SUM, AVERAGE) in the query cannot be matched or computed from the materialized view, it will not be used for rewrite.
Action: none
QSM-01244: join back could not be done on a view for string
Cause: Query Rewrite will not occur if a join back to a table is required to find any missing columns.
Action: none
QSM-01246: join back on correlated columns not allowed (string)
Cause: Query Rewrite will not occur if a join back is required on a column that is referenced by a sub-query.
Action: none
QSM-01247: join back cannot be done on a materialized view that does not have an aggregate (string)
Cause: Query Rewrite can occur by means of a complex join back only during a MAV rewrite.
Action: none
QSM-01248: materialized view does not have the join back level(s) (string)
Cause: Query Rewrite requires joining back to level of a dimension to find missing information.
Action: Consider creating a dimension.
QSM-01251: query rewrite cannot perform rollup due to the presence of a window function
Cause: No query rewrite if a window function is present on a column that requires a roll-up to compute a measure.
Action: none
QSM-01256: query rewrite not possible for this DDL statement
Cause: Some SELECT statements which are part of a DDL expression may be eligible for rewrite. These include CREATE AS SELECT and CREATE OUTLINE statements. The given query expression is a DDL expression, which doesn"t fall in this category.
Action: none
QSM-01257: query rewrite not possible for this DML statement
Cause: Current DML is being done using an updatable view, so it is not eligible for rewrite.
Action: none
QSM-01263: query rewrite not possible when query references a dictionary table or view
Cause: Query rewrite is not allowed if query references any dictionary tables/views.
Action: none
QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query
Cause: A join from the materialized view to any table that eliminates some rows should be be present in the query. Otherwise query rewrite will not occur.
Action: none
QSM-01273: query rewrite not possible because materialized view string has a join not found in query
Cause: Query rewrite may not be possible if the materialized view has some joins that query does not have
Action: none
QSM-01274: query rewrite not possible because materialized view string and query have different number of joins between tables string
Cause: Query rewrite may not be possible if the query has some joins that the materialized view does not have between the same pair of tables.
Action: none
QSM-01279: query rewrite not possible because DML operation occurred on a table referenced by materialized view string
Cause: If any dependent tables of a materialized view undergoes a DML operation, query rewrite may be restricted depending on the query rewrite integrity mode for the session. In this situation, query rewrite will take place only if the rewrite integrity mode is STALE_TOLERATED.
Action: Consider refreshing the materialized view changing the rewrite integrity mode to STALE_TOLERATED.
QSM-01281: query rewrite not possible because either a primary key or a row id is required to join table string with MV string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: none
QSM-01284: materialized view string has an anchor table string not found in query
Cause: A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is not guaranteed to provide all the rows or joined with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Action: none
QSM-01293: anti-join marker not found in materialized view with joins
Cause: Materialized view has outer join while the query has inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: none
QSM-01295: no suitable grouping_id found in materialized view with grouping sets
Cause: If materialized view contains grouping sets, then it also must contain the grouping_id() function. This function must contain all columns in the MV GROUP BY.
Action: none
QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets
Cause: Materialized view with grouping sets contains duplicates and no rewrite is supported for it. For example, GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.
Action: none
QSM-01297: query rewrite not possible because materialized view with grouping sets has more than 64 different keys
Cause: Materialized view with grouping sets has more that 64 different keys in its GROUP BY. No rewrite is supported then.
Action: none
QSM-01298: materialized view string clause more restrictive than query string clause
Cause: The materialized view contains a selection condition in the WHERE or HAVING clause that is more restrictive than the corresponding selection condition in the request query.
Action: Change the selection criteria in the request query to be at least as restrictive as the selection criteria in the materialized view, or drop and recreate the materialized view using less restrictive selection criteria.
QSM-01299: query rewrite not possible because materialized view string is partially stale
Cause: The materialized view is partially stale. It is stale with respect to one or more partitions in one or more of its detail tables. The request query references one or more such detail partitions.
Action: (1) Change the selection criteria of the request to restrict the query to only the fresh portion of the materialized view, or (2) ALTER {SYSTEM|SESSION} QUERY_REWRITE_INTEGRITY = STALE_TOLERATED or (3) refresh the materialized view.
QSM-01303: query rewrite not possible because query references a remote table string
Cause: Query rewrite does not support query with remote tables.
Action: none
QSM-01304: query rewrite not possible because query is using flashback
Cause: Query rewrite does not support flashback.
Action: none
QSM-01307: Partition Containment Tracking (PCT) rewrite is not allowed
Cause: Query rewrite is disabled for PCT through a session parameter
Action: none
QSM-01308: number of "OR"s in query exceeded the maximum value string
Cause: Query rewrite engine cannot process the query if the number of disjuncts (OR"s)in the WHERE clause exceeds the maximum allowed number. The number of disjuncts in the query and the maximum allowed disjuncts are given at the end of the message in the form of (no of disjuncts in query, maximum disjuncts allowed).
Action: none
QSM-01316: window function could not be computed from materialized view string
Cause: The window function in the query could not be computed from the materialized view.
Action: none
QSM-01321: query rewrite not possible because materialized view string has TRUSTED constraints in ENFORCED integrity mode
Cause: A stale materialized view created with USING TRUSTED CONSTRAINTS clause cannot be used when the query rewrite integrity mode is set ENFORCED.
Action: Alter materialized view such that it has the ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW <mv> REFRESH USING ENFORCED CONSTRAINTS
QSM-01332: query rewrite not possible because query has a named array type column
Cause: When the query has a column of named array type, query rewrite cannot be done
Action: none
QSM-01333: query rewrite not possible because query has an ADT column
Cause: When the query has a column of ADT type, query rewrite cannot be done
Action: none
QSM-01334: query rewrite not possible because query has a hidden or nested table column
Cause: When the query has a hidden or nested table column, query rewrite cannot be done
Action: none
QSM-01335: query rewrite not possible because query has an LOB column
Cause: When the query has a column stored in LOB, query rewrite cannot be done
Action: none
QSM-01336: the materialized view you specified (string) was not used to rewrite the query
Cause: A materialized view specified by the user in the input was not used to rewrite the query, either because query rewrite failed or another more optimal materialized view was used to rewrite.
Action: none
QSM-01509: equivalence, string, matched query text
Cause: The query was rewritten using an equivalence, because query text matched the source statement for this equivalence.
Action: none
QSM-01522: a more optimal equivlanece than string was used to rewrite
Cause: Query Rewrite always chooses the most optimal equivalence based on certain parameters, such as cardinality of the equivalence, number of joins etc. The equivalence view specified was found to be less optimal.
Action: none
QSM-01526: query rewrite is disabled for equivalence, string
Cause: Query rewrite could not use this equivalence, because this equivalence was created as disabled.
Action: Enable this equivalence using alter_rewrite_equivalence procedure from package, dbms_advanced_rewrite.
QSM-01533: query rewritten with equivalence, string
Cause: The specified equivalence was used to rewrite the given query.
Action: none
QSM-01565: equivalence, string, cannot compute measure, string, in the query
Cause: If a measure in the query cannot be computed using the measures in the equivalence, then query rewrite will not occur.
Action: none
QSM-01567: equivalence, string, cannot support the query measure, string
Cause: An attempt was made to push a grouping function through an expression specified in the query to transform a measure. Query rewrite will not occur if this measure transformation failed.
Action: none
QSM-01572: equivalence, string, and query have different joins between tables, string
Cause: Anchors, if any, in the equivalenceand query match. But the joins between these anchors in the equivalence and query are different.
Action: none
QSM-01582: Joining equivalence, string, with table, string, not possible
Cause: A column in the query is not found in the equivalence. To obtain the column, a join back of equivalence to the table by means of either the primary key, foreign key or rowid of the table is required. But join backs are not allowed for equivalence rewrite
Action: none
QSM-01584: equivalence, string, has anchor, string, not found in query
Cause: If an anchor which is present in the equivalence is not found in the query, then query rewrite will not take place.
Action: none
QSM-01601: rollup(s) took place on equivalence, string
Cause: If query"s GROUP BY has one of the higher levels of columns found in the equivalence, then the lower level columns in the equivalence will be rolled up to compute the desired results.
Action: none
QSM-01602: equivalence, string, requires join back to table, string, on column, string
Cause: A column in the query does not appear in the equivalence. Query rewrite will try to obtain this column from the base table, by doing a join back to that column with a materialized view. But join backs are not allowed for equivalence rewrite as the required constraints are not guaranteed to be found on the tables in the destination statement of the equivalence.
Action: none
QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query
Cause: All lossy joins in the equivalence must be present in the query for query rewrite to occur.
Action: none
QSM-01617: equivalence definition is disabled
Cause: There is an equivalence defition that could have been probably used by query rewrite to rewrite the query. But this equivalence is disabled.
Action: none
QSM-01618: equivalence, string, is enabled for text match rewrite only
Cause: This equivalence was created for text match rewrite only
Action: none
QSM-01619: equivalence cannot be used in ENFORCED integrity mode
Cause: An equivalence cannot be used for query rewrite when the query rewrite integrity mode is set to ENFORCED.
Action: none
QSM-01621: join backs to base tables not allowed with an equivalence
Cause: Query rewrite needs to do a join back to a base table column to answer this query. But join back is not allowed for an equivalence rewrite
Action: none
QSM-02001: clustered mv container table
Cause: The capability in question is not supported on a materialized view that has a clustered container table.
Action: Recreate the materialized view using a conventional container table.
QSM-02002: DISTINCT aggregate measure in SELECT list
Cause: The capability in question is not supported when the materialized view uses the DISTINCT qualifier on an aggregate function.
Action: Remove the DISTINCT qualifier.
QSM-02003: aggregate function nested within an expression
Cause: The capability in question is not supported when the materialized view contains an aggregate function invocation nested within an outer expression.
Action: Re-phrase the expression such that the aggregate function invocation is not nested.
QSM-02004: grouping column omitted from SELECT list
Cause: The capability in question is not supported when the materialized view contains a column or expression in the GROUP BY clause that is not also present in the list of output select expressions.
Action: Include all GROUP BY expressions in the output select list.
QSM-02005: named view in FROM list
Cause: The capability in question is not supported when a named view appears in the FROM list.
Action: Remove the named view from the FROM list.
QSM-02006: subquery in FROM list
Cause: The capability in question is not supported when a subquery appears in the FROM list.
Action: Remove the subquery from the FROM list.
QSM-02007: multiple instances of the same table or view
Cause: The capability in question is not supported when the same table or view occurs more than once in the FROM list.
Action: Re-phrase the query to avoid multiple instances of the same table. For instance,
QSM-02008: non-join filter condition in WHERE or HAVING clause
Cause: The capability in question is not supported when the materialized view has a selection condition (an expression not representing a join) in the WHERE or HAVING clauses.
Action: Remove the selection filter expression.
QSM-02009: non-inner join
Cause: The capability in question is only supported with inner joins.
Action: Re-phrase the query using an inner join. Remove any outer joins.
QSM-02010: join predicate with operator other than equals (=)
Cause: The capability in question is not supported when the materialized uses a relationship operator other than equals ("=") in a join in the WHERE clause. This is known as a non-equijoin.
Action: Re-phrase the query to avoid the non-equijoin.
QSM-02011: a HAVING clause is present
Cause: The capability in question is not supported when the materialized view uses a HAVING clause.
Action: Remove the HAVING clause.
QSM-02012: a CONNECT BY clause is present
Cause: The capability in question is not supported when the materialized view uses a CONNECT BY clause.
Action: Re-phrase the query to avoid use of the CONNECT BY clause.
QSM-02013: SELECT list includes a RAW data type expression
Cause: The capability in question is not supported when the materialized view uses RAW data type in an expression.
Action: Remove the reference to the RAW expression.
QSM-02014: GROUP BY expression other than a column
Cause: The capability in question is not supported when the materialized view uses an expression other than a simple column reference in the GROUP BY clause.
Action: Re-phrase the query to use only simple column expressions in the GROUP BY clause.
QSM-02015: Index Organized Table (IOT) present in FROM list
Cause: The capability in question is not supported when the materialized view references an Index Organized Table in the FROM list.
Action: Remove the reference to the Index Organized Table.
QSM-02016: clustered table in FROM list
Cause: The capability in question is not supported when the materialized view references a clustered table in the FROM list.
Action: Remove the reference to the clustered table in the FROM list.
QSM-02017: subquery present in the HAVING clause
Cause: The capability in question is not supported when the materialized view uses a subquery in the HAVING clause.
Action: Re-phrase the query to avoid the subquery in the HAVING clause.
QSM-02018: subquery present in the WHERE clause
Cause: The capability in question is not supported when the materialized view uses a subquery in the WHERE clause.
Action: Re-phrase the query to avoid the subquery in the WHERE clause.
QSM-02019: mv references another mv in FROM clause
Cause: The capability in question is not supported when the materialized view is nested (i.e., when it references another materialized view in its FROM list).
Action: Re-phrase the query to avoid reference to the other materialized view.
QSM-02020: container column not in SELECT list with NOT NULL constraint
Cause: The capability in question is not supported when the materialized view"s container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Action: Disable or remove the NOT NULL constraint.
QSM-02021: set operator encountered in mv
Cause: The capability in question is not supported when the materialized view uses set operators such as UNION, UNION ALL, MINUS, etc.
Action: Re-phrase the query to avoid the use of set operators.
QSM-02022: aggregate selections
Cause: The capability in question is not supported when the materialized view uses an aggregate expression in the HAVING clause.
Action: Re-phrase the query to avoid the use of an aggregate in the HAVING clause.
QSM-02023: nested cursor
Cause: The capability in question is not supported when the materialized view uses a nested cursor expression.
Action: Re-phrase the query to avoid use of a nested cursor expression.
QSM-02024: no GROUP BY clause
Cause: The capability in question is not supported when the materialized view does not use a GROUP BY clause.
Action: Re-phrase the query to use a GROUP BY clause.
QSM-02025: no aggregate functions
Cause: The capability in question is not supported when the materialized view uses no aggregate functions.
Action: Re-phrase the query to use aggregate functions.
QSM-02026: non-AND conjunction in WHERE clause
Cause: The capability in question is not supported when the materialized view uses a conjunction other than AND (such as OR) in the WHERE clause.
Action: Re-phrase the query to avoid use of the non-AND conjunction.
QSM-02027: group by ROLLUP
Cause: The capability in question is not supported when the materialized view uses the ROLLUP operator in the GROUP BY clause.
Action: Re-phrase the query to avoid use of the ROLLUP operator.
QSM-02028: group by CUBE
Cause: The capability in question is not supported when the materialized view uses the CUBE operator in the GROUP BY clause.
Action: Re-phrase the query to avoid use of the CUBE operator.
QSM-02029: PL/SQL function invocation
Cause: The capability in question is not supported when the materialized view invokes a PL/SQL function.
Action: Re-phrase the query to avoid use of PL/SQL functions.
QSM-02030: reduced precision specified for prebuilt mv
Cause: The capability in question is not supported when the materialized view is created with the WITH REDUCED PRECISION clause.
Action: DROP the materialized view and re-create it without using the WITH REDUCED PRECISION clause.
QSM-02031: materialized view cannot support any type of query rewrite
Cause: of the problem.
Action: Examine the other messages and documentation to determine the
QSM-02032: no joins are present in the WHERE clause
Cause: The capability in question is not supported when the materialized view includes no join conditions in the WHERE clause.
Action: Re-phrase the query to include a join.
QSM-02033: no filter conditions are present in the WHERE clause
Cause: The capability in question is not supported when the materialized view includes no filter selection conditions in the WHERE clause.
Action: Add a filter condition.
QSM-02034: no joins are present in the HAVING clause
Cause: The capability in question is not supported when the materialized view includes no joins in the HAVING clause.
Action: Re-phrase the query to include a join.
QSM-02035: no filter conditions are present in the HAVING clause
Cause: The capability in question is not supported when the materialized view includes no filter condition in the HAVING clause.
Action: Re-phrase the query to include a join.
QSM-02036: in-list present in mv
Cause: The capability in question is not supported when the materialized view uses an IN list.
Action: Re-phrase the query to avoid the use of IN lists.
QSM-02037: cannot evaluate constant expression at compile time
Cause: The capability in question is not supported when the materialized view uses a compile-time non-constant expression in a filter condition in the WHERE or HAVING clauses. For example, WHERE X=1 uses a compile-time constant expression in a filter condition. WHERE X=MY_PLSQL_FUNCTION() uses a compile-time non-constant expression in a filter condition.
Action: Re-phrase the query to avoid the use of a compile-time non-constant expressions in filter conditions.
QSM-02038: Partition Change Tracking (PCT) is enabled
Cause: The Partition Change Tracking (PCT) capability is supported for this materialized view.
Action: No action is needed.
QSM-02039: top level mv query uses grouping sets
Cause: The capability in question is not supported when the materialized view use grouping sets.
Action: Re-phrase the query to avoid use of grouping sets.
QSM-02040: top level query contains GSets and the key is too long for rewrite
Cause: The capability in question is not supported when the materialized view uses a grouping set with too many keys.
Action: Reduce the number of grouping set keys.
QSM-02041: nested aggregate function
Cause: The capability in question is not supported when the materialized view nests an aggregate function invocation as an argument to another aggregate function.
Action: Re-phrase the query to avoid the nested aggregate function invocation.
QSM-02042: view or subquery in from list
Cause: The capability in question is not supported when the materialized view references a view or subquery in the FROM list.
Action: Re-phrase the query to avoid the use of views or subqueries in in the FROM list.
QSM-02044: ORDER BY clause in mv
Cause: The capability in question is not supported when the materialized view includes an ORDER BY clause.
Action: Remove the ORDER BY clause.
QSM-02045: START WITH clause in mv
Cause: The capability in question is not supported when the materialized view includes a START WITH clause.
Action: Re-phrase the query to avoid the use of the START WITH clause.
QSM-02047: window function in mv
Cause: The capability in question is not supported when the materialized view uses a window function.
Action: Re-phrase the query to avoid the use of window functions.
QSM-02048: outer join in mv
Cause: The capability in question is not supported when the materialized view uses an outer join.
Action: Re-phrase the query to avoid the use of outer joins.
QSM-02049: subquery using the ANY clause in mv
Cause: The capability in question is not supported when the materialized view uses the ANY clause with a subquery.
Action: Re-phrase the query to avoid the use of the ANY clause.
QSM-02050: subquery using the ALL clause in mv
Cause: The capability in question is not supported when the materialized view uses the ALL clause with a subquery.
Action: Re-phrase the query to avoid the use of the ALL clause.
QSM-02051: subquery using the NOT EXISTS clause in mv
Cause: The capability in question is not supported when the materialized view uses the NOT EXISTS with a subquery.
Action: Re-phrase the query to avoid the use of the NOT EXITS clause.
QSM-02052: subquery using a select list in mv
Cause: The capability in question is not supported when the materialized view uses a select list.
Action: Re-phrase the query to avoid the use of a select list.
QSM-02053: collection subquery in mv
Cause: The capability in question is not supported when the materialized view uses a collection subquery.
Action: Re-phrase the query to avoid the use of collection subqueries.
QSM-02054: DISTINCT clause in select list in mv
Cause: The capability in question is not supported when the materialized view uses the DISTINCT clause in the select list.
Action: Re-phrase the query to avoid the use of the DISTINCT clause.
QSM-02055: mv references a packed object table or view
Cause: The capability in question is not supported when the materialized view references a packed object table or view.
Action: Re-phrase the query to avoid the use of the packed object tables or views.
QSM-02056: correlated variable and outer join in mv
Cause: The capability in question is not supported when the materialized view uses a correlated variable and an outer join.
Action: Re-phrase the query to avoid the use of the correlated variables or outer joins.
QSM-02057: ROWNUM referenced in mv
Cause: The capability in question is not supported when the materialized view references the ROWNUM function.
Action: Re-phrase the query to avoid the use of the ROWNUM function.
QSM-02058: set operator in mv and compatibility mode is less than 9.0
Cause: The capability in question is not supported when the materialized view uses a set operator and the compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the use of set operators or set the compatibility mode to 9.0 or greater.
QSM-02059: join may produce duplicate rows in mv
Cause: The capability in question is not supported when the materialized view contains a join condition that can result in duplicate rows in the materialized view.
Action: Re-phrase the query to avoid the occurrence of duplicate rows in the materialized view.
QSM-02061: one or more joins present in mv
Cause: The capability in question is not supported when the materialized view contains joins.
Action: Re-phrase the query to avoid the use of the joins.
QSM-02062: GROUP BY clause in mv
Cause: The capability in question is not supported when the materialized view uses the GROUP BY clause.
Action: Re-phrase the query to avoid the use of the GROUP BY clause.
QSM-02063: aggregate function in mv
Cause: The capability in question is not supported when the materialized view uses an aggregate function.
Action: Re-phrase the query to avoid the use of the aggregate functions.
QSM-02064: subquery in mv
Cause: The capability in question is not supported when the materialized view uses a subquery.
Action: Re-phrase the query to avoid the use of the subqueries.
QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details
Cause: The capability in question is not supported because an attempt to create the materialized view would result in an error.
Action: Examine the associated Oracle error code in the RELATED_NUM column and the Oracle error text in the RELATED_TEXT column and address the problem.
QSM-02067: no partition key or PMARKER or join dependent expression in select list
Cause: The capability in question is not supported when the materialized view unless the select list (and group by list if a GROUP BY clause is present) includes the partition key or PMARKER function reference to the table in question or an expression join dependent on the partitioning column of the table in question.
Action: Add the partition key or a PMARKER function reference or a join dependent expression to the select list (and the GROUP BY clause, if present).
QSM-02068: relation is not a partitioned table
Cause: The capability in question is not supported when the relation in question is not a partitioned table.
Action: Change the query to reference a partitioned table.
QSM-02069: PCT not supported with multi-column partition key
Cause: The capability in question is not supported when the table in is partitioned on a multi-column key.
Action: Re-phrase the query to reference a table partitioned on a single column key.
QSM-02070: PCT not supported with this type of partitioning
Cause: The capability in question is not supported when the table in question uses certain types of partitioning.
Action: Re-phrase the query to reference a table that is uses a type of partitioning that is supported for this capability.
QSM-02071: internal error: undefined PCT failure code
Cause: An internal Oracle error has occurred.
Action: Report the problem through your normal support channels.
QSM-02072: requirements not satisfied for fast refresh of nested mv
Cause: The capability in question is not supported because one or more of the requirements for this capability have not been satisfied.
Action: Examine the relevant nested materialized view documentation in the Warehouse Guide and address the problem.
QSM-02073: non-primary key RepAPI mv is not fast refreshable
Cause: Fast refresh is supported for RepAPI materialized views only if it is also a primary key materialized view.
Action: Re-design the materialized view to be a primary key materialized view.
QSM-02074: materialized view over Heterogeneous Services link
Cause: The capability in question is not supported when the materialized view uses a heterogeneous link.
Action: Re-design the materialized view to avoid the use of the heterogeneous links.
QSM-02075: materialized view on synonym
Cause: The capability in question is not supported when the materialized view references a synonym, if the compatible parameter is earlier than 10.2.0.
Action: Re-phrase the query to avoid the use of the synonyms.
QSM-02076: sequence number in the mv log is newer than last refresh
Cause: The timestamp of the sequence number in the mv log was after the last refresh time.
Action: A complete refresh is required before the next fast refresh.
QSM-02077: mv log is newer than last full refresh
Cause: The capability in question is not supported when the relevant materialized view log was created after the creation or most recent complete refresh of the materialized view.
Action: Perform a complete refresh of the materialized view.
QSM-02078: mv log must have new values
Cause: The capability in question is not supported when the relevant materialized view log omits new values.
Action: Re-create the materialized view log using the NEW VALUES clause.
QSM-02079: mv log must have ROWID
Cause: The capability in question is not supported when the relevant materialized view log omits ROWIDs.
Action: Re-create the materialized view log using the ROWID clause.
QSM-02080: mv log must have primary key
Cause: The capability in question is not supported when the relevant materialized view log omits primary keys.
Action: Re-create the materialized view log using the PRIMARY KEY clause.
QSM-02081: mv log does not have all necessary columns
Cause: The capability in question is not supported when the relevant materialized view log omits columns referenced in the select list of the materialized view.
Action: Re-create the materialized view log and include all columns referenced in the select list.
QSM-02082: problem with mv log
Cause: The capability in question is not supported because of a problem the materialized view log in question.
Action: Examine the relevant materialized view log and fast refresh documentation in the Warehouse Guide and address the problem.
QSM-02083: mv references PL/SQL function that maintains state
Cause: The capability in question is not supported when the materialized view references a PL/SQL function that maintains state and which may not return the same value every time it is invoked against the same set of rows.
Action: Re-phrase the query to avoid such a PL/SQL function. Or modify the PL/SQL function to avoid state maintenance and change its declaration accordingly.
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
Cause: The capability in question is not supported when the materialized view uses the DISTINCT clause in this context.
Action: Re-phrase the query to avoid the use of the DISTINCT clause.
QSM-02086: mv uses the MIN or MAX aggregate functions
Cause: The capability in question is not supported when the materialized view uses the MIN or MAX function.
Action: Re-phrase the query to avoid the use of the MIN or MAX functions.
QSM-02088: mv omits at least one grouping key from the select list
Cause: The capability in question is not supported when the materialized view omits any grouping expressions from the select list.
Action: Include all GROUP BY expressions in the select list.
QSM-02090: SELECT includes an expression that is not just a column
Cause: The capability in question is not supported when the materialized view uses an expression in the select list that is not a simple column reference.
Action: Re-phrase the query to avoid the use of the expressions that are not simple column references.
QSM-02091: mv references a non-repeatable or session-sensitive expression
Cause: The capability in question is not supported when the materialized view uses an expression that may not return the same value each time it is invoked against the same set of rows or that may return different values depending on session parameters.
Action: Re-phrase the query to avoid the use of such expressions.
QSM-02092: mv references a sequence number
Cause: The capability in question is not supported when the materialized view references a sequence number.
Action: Re-phrase the query to avoid the reference to sequence numbers.
QSM-02093: mv uses an object REF clause
Cause: The capability in question is not supported when the materialized view uses an object REF clause.
Action: Re-phrase the query to avoid the use of an object REF clause.
QSM-02096: mv references a named view
Cause: The capability in question is not supported when the materialized view references a view.
Action: Re-phrase the query to avoid references to views.
QSM-02099: mv references a remote table or view in the FROM list
Cause: The capability in question is not supported when the materialized view references a remote table or view in the FROM list.
Action: Re-phrase the query to avoid references to remote tables or views.
QSM-02101: mv references a synonym in the FROM list
Cause: The capability in question is not supported when the materialized view references a synonym in the FROM list.
Action: Re-phrase the query to avoid the reference to the synonym.
QSM-02102: mv FROM list references an object in the SYS schema
Cause: The capability in question is not supported when the materialized view references an object in the SYS schema.
Action: Re-phrase the query to avoid the reference to the SYS schema.
QSM-02104: aggregate function in a filter condition in the HAVING clause
Cause: The capability in question is not supported when the materialized view references an aggregate function in a filter condition in the HAVING clause.
Action: Re-phrase the query to avoid the use of aggregates in filter conditions in the HAVING clause.
QSM-02106: mv uses a filter condition in the WHERE or HAVING clause
Cause: The capability in question is not supported when the materialized view includes a filter condition in the WHERE or HAVING clause.
Action: Re-phrase the query to avoid the use of filter conditions in the WHERE or HAVING clauses.
QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join
Cause: The capability in question is not supported when the materialized view uses these types of joins.
Action: Re-phrase the query to avoid the use of these types of joins.
QSM-02113: expression in select list references multiple tables or views
Cause: The capability in question is not supported when the materialized view includes an expression in the select list that references multiple tables or views.
Action: Re-phrase the query to avoid the use of the such expressions.
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
Cause: The capability in question is not supported when the materialized view has no GROUP BY clause, no aggregates and compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the include a GROUP BY clause or an aggregate function. Or set compatibility mode to 9.0 or greater.
QSM-02115: mv references a remote object and is refreshed ON COMMIT
Cause: The capability in question is not supported when the materialized view references a remote object and is refreshed ON COMMIT.
Action: Re-phrase the query to avoid the reference to the remote object or alter the materialized view to be refreshed ON DEMAND.
QSM-02116: mupltiple master sites
Cause: The capability in question is not supported when the materialized view references multiple remote objects that reside at different remote instances.
Action: Re-phrase the query to avoid the use of multiple master sites.
QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)
Cause: The capability in question is not supported when the materialized view uses grouping sets but omits the relevant GROUPING_ID or GROUPING functions.
Action: Re-phrase the query to include the relevant GROUPING_ID or GROUPING functions.
QSM-02118: duplicate grouping sets
Cause: The capability in question is not supported when the materialized view redundantly references grouping sets.
Action: Re-phrase the query to avoid the use of the redundant grouping sets.
QSM-02119: internal error while analyzing required supporting aggregates
Cause: An internal Oracle error has occurred.
Action: Report the problem through your normal support channels.
QSM-02120: compatibility mode must be 9.0 or higher
Cause: The capability in question is not supported when the compatibility mode is less than 9.0.
Action: Set the compatibility mode to 9.0 or higher.
QSM-02121: set operator in a context not supported for fast refresh
Cause: The capability in question is not supported when the materialized view uses a set operator in this context.
Action: Re-phrase the query to avoid the use of the set operator.
QSM-02122: compatibility mode must be 8.1 or higher
Cause: The capability in question is not supported when the compatibility mode is less than 8.1.
Action: Set the compatibility mode to 8.1 or higher.
QSM-02123: subquery and UNION mv"s must be primary key mv"s
Cause: The capability in question is not supported when the materialized view is not a primary key materialized view and uses subqueries or the union operator in this context.
Action: Re-create the materialized view as a primary key materialized view.
QSM-02124: object type in WHERE clause
Cause: The capability in question is not supported when the materialized view references an object type in the WHERE clause.
Action: Re-phrase the query to avoid the reference to the object type.
QSM-02125: subquery join conditions don"t meet requirements for capability
Cause: The capability in question is not supported when the materialized view uses a subquery in a join in this way.
Action: Examine the relevant replication documentation concerning subquery materialized views and address the problem.
QSM-02126: no rowid at master site
Cause: The capability in question is not supported when the materialized view references a remote site that does not support rowids.
Action: Re-phrase the query to avoid the reference to the remote site.
QSM-02127: not supported for this type mv by Oracle version at master site
Cause: The capability in question is not supported when the materialized view uses certain constructs and references an older version, remote Oracle instance.
Action: Re-phrase the query to avoid the use of the construct or upgrade the remote Oracle instance.
QSM-02128: does not meet the requirements of a primary key mv
Cause: The capability in question is not supported when the materialized view fails to meet the requirements of a primary key materialized view.
Action: Examine the relevant primary key materialized view replication documentation and address the problem.
QSM-02129: join or filter condition(s) are complex
Cause: The capability in question is not supported when the materialized view uses a complex join or filter condition.
Action: Re-phrase the query to simplify the join or filter condition.
QSM-02130: expression not supported for fast refresh
Cause: The capability in question is not supported when the materialized view references certain, complex expressions.
Action: Re-phrase the query to simplify the expression.
QSM-02131: agg(expr) requires correspondng SUM(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the SUM function on the same argument.
Action: Add the SUM function to the select list.
QSM-02132: agg(expr) requires correspondng COUNT(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the COUNT function on the same argument.
Action: Add the COUNT function to the select list.
QSM-02133: agg(expr) requires correspondng MIN(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the MIN function on the same argument.
Action: Add the MIN function to the select list.
QSM-02134: agg(expr) requires correspondng MAX(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the MAX function on the same argument.
Action: Add the MAX function to the select list.
QSM-02135: agg(expr) requires correspondng AVG(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the AVG function on the same argument.
Action: Add the AVG function to the select list.
QSM-02136: agg(expr) requires correspondng VARIANCE(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the VARIANCE function on the same argument.
Action: Add the VARIANCE function to the select list.
QSM-02137: agg(expr) requires correspondng STDDEV(expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the STDDEV function on the same argument.
Action: Add the STDDEV function to the select list.
QSM-02138: agg(expr) requires correspondng agg(expr*expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of that same aggregate function on the square of the same argument.
Action: Add an invocation of the same aggregate function on the square of the same argument (that is, the argument multiplied by itself).
QSM-02139: agg(expr) requires correspondng agg(expr+expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of that same aggregate function on the same argument added to the same argument.
Action: Add the indicated aggregate function to the select list.
QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of the SUM function on the square of the same argument (the argument multiplied by itself).
Action: Add the SUM function on the square of the argument.
QSM-02141: the reason why the capability is disabled has escaped analysis
Cause: The EXPLAIN_MV analysis engine has failed to capture the reason why the given capability is not possible.
Action: Report the problem through your normal problem reporting channels.
QSM-02142: COUNT(*) is not present in the select list
Cause: The materialized view query omits COUNT(*) from the select list.
Action: Add COUNT(*) to the select list.
QSM-02143: SUM(expr) without COUNT(expr)
Cause: SUM(expr) occurs in the select list without a corresponding COUNT(expr).
Action: Add COUNT(expr) to the select list.
QSM-02144: aggregate functions are present without a GROUP BY clause
Cause: One or more aggregate functions are present in the select list but a GROUP BY clause is not used.
Action: Add a GROUP BY clause.
QSM-02145: GROUP BY clause is present but no aggregate functions are used
Cause: A GROUP BY clause is used but no aggregate functions are present in the select list.
Action: Add an aggregate function to the select list.
QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled
Cause: REFRESH_FAST_AFTER_ONETAB_DML is disabled for the same reason that REFRESH_FAST_AFTER_INSERT is disabled.
Action: Correct the problem with REFRESH_FAST_AFTER_INSERT.
QSM-02147: default date format is sensitive to session settings
Cause: You have specified a date conversion operation using either the default format or an incomplete format. The default date format or an incomplete format is sensitive to session settings, and therefore may not be reproducible across different environments.
Action: Specify a complete date format string.
QSM-02148: many to many subquery joins require 9.0 compatibility or higher
Cause: You have specified a many to many join in your materialized view while running in less than 9.0 compatibility mode.
Action: Set your compatibility mode to 9.0 or higher or restructure the materialized view query.
QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher
Cause: You have specified a materialized view that uses some combination of the following: joins aggregation filter conditions in the WHERE clause a remote relation in the FROM list a SUM(x) function without a corresponding COUNT(x) function an omitted COUNT(*) aggregate function a MIN() or MAX() aggregate function in combination with the REFRESH ON COMMIT option while running in less than 9.0 compatibility mode.
Action: Set your compatibility mode to 9.0 or higher or restructure the materialized view query.
QSM-02150: select lists must be identical across the UNION operator
Cause: You have specified a materialized view using the UNION operator and the respective queries on each side of the UNION operator do not have the same select list. The RELATED_NAME column shows the alias of the first different select list item. The RELATED_NUM column shows the offset from the SELECT keyword to the start of this select list item.
Action: Restructure the materialized view query such that the respective sides of the UNION operator have identical select lists.
QSM-02151: subquery or named view in FROM list and < 9.0 compatibility
Cause: You have specified a materialized view that references a subquery or named view in its top level FROM list while running in less than 9.0 compatibility mode.
Action: Set compatibility mode to 9.0 or higher or restructure the materialized view query.
QSM-02152: subquery or named view in FROM list even after view merging
Cause: You have specified a materialized view that references a subquery ore named view in its top level FROM list that could not be merged during the view merging process.
Action: Restructure the materialized view query.
QSM-02153: inline view or subquery in FROM list not supported for this type MV
Cause: You have specified a materialized view that references an inline view or a subquery. The indicated capability is not supported for this type of materialized view.
Action: Restructure the materialized view query.
QSM-02154: MV is not fast refreshable even with view merging
Cause: You have a materialized view with view in the FROM clause, however it does not meet the criteria for fast refresh after view merging.
Action: Restructure the materialized view query to remove the offending view or the complex construct in the view.
QSM-02161: see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled
Cause: REFRESH_FAST_AFTER_ANY_DML is disabled for the same reason that REFRESH_FAST_AFTER_ONETAB_DML is disabled.
Action: Correct the problem with REFRESH_FAST_AFTER_ONETAB_DML.
QSM-02162: the detail table does not have a materialized view log
Cause: The fast refresh cannot be performed because the master table does not contain a materialized view log.
Action: Use the CREATE MATERIALIZED VIEW LOG command to create a materialized view log on the master table.
QSM-02163: cannot use object id columns from materialized view log
Cause: The materialized view log either does not have object id columns logged, or the timestamp associated with the object id columns is more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add object id columns to the materialized view log, if required.
QSM-02169: the materialized view contains partition extended table name
Cause: Fast refresh of materialized aggregate views and/or materialized join views are not supported if they were defined using partition extended table names.
Action: Create the fast refreshable materialized view without using partition extended table names or create the materialized view as a complete refresh materialized view.
QSM-02170: tables must be identical across the UNION operator
Cause: You have specified a materialized view using the UNION operator and the tables on each side of the UNION operator do not match. Fast refresh is not supported in this context.
Action: Restructure the materialized view query such that the respective sides of the UNION operator have the same table.
QSM-02171: the materialized view has a join operation in the outer UNION block
Cause: Fast refresh is not supported if a materialized view having the UNION operator contains a join operation.
Action: Rewrite the materialized view query without the join.
QSM-02173: the unique constraints does not exist on the join columns of the inner table
Cause: If there are outer joins, unique constraints must exist on the join columns of the inner table. Othwerwise, the materialized view can not be fast refreshable.
Action: none
QSM-02174: the materialized view does not have a UNION ALL marker column
Cause: For a materialized view with UNION ALL to be fast refreshable, it must have a UNION ALL marker column. This is a constant column, at the same ordinal position in each query block and must have distinct values in each query block.
Action: Add a UNION ALL marker column to each query block in the UNION ALL query defining the materialized view.
QSM-02175: some query block in UNION ALL MV is not fast refreshable
Cause: For a materialized view with UNION ALL to be fast refreshable, each query block must conform to a fast refreshable materialized join view or materialized aggregate view.
Action: Check each query block in the UNION ALL to ensure it is either a materialized view with joins or aggregates.
QSM-02176: MV with UNION ALL in a view is too complex
Cause: If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view"s defining query cannot have any clauses other than SELECT or FROM. Other clauses such as WHERE, HAVING, CONNECT BY, or GROUP BY are not allowed. Further more, the FROM clause should have only one item.
Action: Remove any clauses besides SELECT and FROM from the materialized view"s defining query.
QSM-02177: MV with UNION ALL in a view must match the view"s SELECT list
Cause: If a materialized view has a view whose definition involves a UNION ALL query, then the materialized view"s select list must match the underlying view"s select list exactly. It must not have any expressions and must not have add/drop/reorder columns from the underlying view.
Action: Use select * when defining a materialized view with a UNION ALL in a view.
QSM-02178: MV has a view with UNION ALL that is not fast refreshable
Cause: The materialized view has a view whose definition involves a UNION ALL query that does not satisfy the requirements for fast refresh.
Action: Check that the defining query of the view being referenced in the materialized view satisfies conditions for fast refresh of a UNION ALL materialized view.
QSM-02179: MV with UNION ALL requires compatibility >= 9.2
Cause: The setting of the COMPATIBLE initialization parameter is less than 9.2.0.
Action: Set COMPATIBLE to 9.2.0 or higher.
QSM-02180: no primary key constraint in the master table
Cause: The explain_mview assumes that the materialized view is going to be created as the Primary Key materialized view. A Primary Key materialized view can not be created if the base table does not have a primary key constraint.
Action: Add a primary key constraint to the base table, or create the materialized view as Rowid MV by specifying the WITH ROWID option. If the materialized view is a Rowid MV, then it should be able to do complete refresh and even fast refresh, given that the materialized view log on the master table has a rowid.
QSM-02181: a SPREADSHEET clause is present
Cause: The capability in question is not supported when the materialized view uses a SPREADSHEET clause.
Action: Remove the SPREADSHEET clause.
QSM-02182: PCT is enabled through a join dependency
Cause: The capability in question is not supported when the materialized view does not contain some expression join dependent on the partitioning key of relation in question in the select list. For definition of join dependency, please look at Oracle documentation.
Action: Change the query to contain the partitioning key
QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET
Cause: The capability in question is not supported when the expression is not in the PARTITION BY clause
Action: Change the query so that the expression is in the PARTITION BY
QSM-02184: Expression to enable PCT cannot be rolled up
Cause: The capability in question is not supported when the expression is rolled up
Action: Change the query so that the expression is not rolled up
QSM-02185: no partition key or PMARKER in select list
Cause: The capability in question is not supported when the materialized view unless the select list (and group by list if a GROUP BY clause is present) includes either the partition key of or a PMARKER function reference to the table in question.
Action: Add the partition key or a PMARKER function reference to the select list (and the GROUP BY clause, if present).
QSM-02186: PARTITIONED OUTER JOIN is present
Cause: The capability in question is not supported when the materialized view has PARTITIONED OUTER JOIN.
Action: Remove PARTITIONED OUTER JOIN.
QSM-02187: materialized view on external table
Cause: The capability in question is not supported when the materialized view references an external table.
Action: Re-phrase the query to avoid the use of the external tables.
QSM-02188: named view in FROM list not supported for this type MV
Cause: You have specified a materialized view that references a named view The indicated capability is not supported for this type of materialized view.
Action: Restructure the materialized view query.
QSM-02189: materialized view definition changes
Cause: The definition of the materialized view has changed. Usually redefining the synonym or table in the definition can cause this. The materialized view can not be fast refreshed.
Action: Complete refresh or recreate the materialized view.
QSM-03112: Invalid CREATE MATERIALIZED VIEW statement string
Cause: The CREATE MATERIALIZED VIEW statement that was passed into the procedure was not a valid one.
Action: Check the reason(s) following the error or the statement and retry the operation.
QSM-03113: Cannot tune the MATERIALIZED VIEW statement string
Cause: The MATERIALIZED VIEW statement could not be tuned.
Action: Check the reason(s) following the error or the statement and retry the operation.
QSM-03114: Cannot tune FOR UPDATE materialized view
Cause: The materialized view was created with the FOR UPDATE option.
Action: Rephrase the statement to avoid the use of the FOR UPDATE option.
QSM-03115: Cannot tune materialized view ON PREBUILT table
Cause: The materialized view was created on a prebuilt table.
Action: Rephrase the statement to avoid the use of the ON PREBUILT option.
QSM-03116: The materialized view is already optimal and cannot be tuned any further
Cause: The materialized view has the capabilities that are specified in the statement.
Action: none
QSM-03117: Cannot tune the materialized view to be fast refreshable
Cause: The materialized view could not be tuned or decomposed to be fast refreshable.
Action: Run the dbms_mview.explain_mview to find out the reason.
QSM-03118: Cannot tune the materialized view for general rewrite
Cause: The materialized view could not be tuned for supporting general rewrite.
Action: Run the dbms_mview.explain_mview to find out the reason.
QSM-03119: The WHERE/HAVING clause is too complex for general query rewrite
Cause: The WHERE/HAVING was too complex for general rewrite.
Action: Try to simplify the WHERE/HAVING clause in the materialized view defining query.
QSM-03120: Cannot create materialized view log on encrypted columns
Cause: There were encrypted columns in materialized view defining query.
Action: Try to remove the encrypted columns in the materialized view defining query.