{"id":2266,"date":"2016-09-22T21:32:54","date_gmt":"2016-09-22T18:32:54","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2266"},"modified":"2017-02-15T21:34:56","modified_gmt":"2017-02-15T18:34:56","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-18200-to-ora-19000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-18200-to-ora-19000\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18200 to ORA-19000"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18200 to ORA-19000<\/strong><\/p>\n

\n
ORA-18201: The input MDX string is empty.<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input MDX (MultiDimensional eXpression) string was empty.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input MDX (MultiDimensional eXpression) string.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18202: MDX parser error at line\u00a0string<\/i>, column\u00a0string<\/i>:\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input MDX (MultiDimensional eXpression) query had invalid syntax.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax error for the MDX (MultiDimensional eXpression) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18203: The MDX\u00a0string<\/i>\u00a0string<\/i>\u00a0is not currently supported.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input MDX (MultiDimensional eXpression) query contained an unsupported feature.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the MDX (MultiDimensional eXpression) query to use only supported features.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18204: The identifier at line\u00a0string<\/i>, column\u00a0string<\/i>\u00a0has no closing right bracket (]) character.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The delimited identifier had no closing right bracket (]) character.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax error for the MDX (MultiDimensional eXpression) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18205: Invalid arguments for function\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The function had invalid arguments.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the syntax error for the MDX (MultiDimensional eXpression) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18220: The type of the expression in\u00a0string<\/i>\u00a0is\u00a0string<\/i>.\u00a0string<\/i>\u00a0is expected.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MDX (MultiDimensional eXpression) query had the wrong type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an expression with a valid type.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-18221: The argument\u00a0string<\/i>\u00a0in\u00a0string<\/i>\u00a0has different hierarchies.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An argument had different hierarchies.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use uniform hierarchies.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18222: Hierarchy\u00a0string<\/i>\u00a0already appears in\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A hierarchy was repeated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use disjoint hierarchies.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18223: Invalid identifier for dimension “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one hierarchy existed for dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the hierarchy with the dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18224: invalid cube identifier “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The cube identifier was specified incorrectly.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid cube identifier.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18225: The type of argument\u00a0string<\/i>\u00a0of\u00a0string<\/i>\u00a0is\u00a0string<\/i>.\u00a0string<\/i>\u00a0is expected.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An argument of the function had the wrong type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an argument with a valid type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18226: argument\u00a0string<\/i>\u00a0does not contain the hierarchy “string<\/i>” in argument\u00a0string<\/i>\u00a0in\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The hierarchy in one argument did not exist in the SET argument.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an expression with the hierarchy from the set in the SET argument.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18227: The index is out of range in\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The index was out of range.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an index within the range.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18228: The set of argument\u00a0string<\/i>\u00a0of\u00a0string<\/i>\u00a0contains multiple hierarchies. Only one hierarchy is expected.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The set argument had more than one hierarchy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a SET argument that contains only one hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18229: The hierarchy\u00a0string<\/i>\u00a0is used more than once in arguments of\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The hierarchy was used more than once.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use arguments that contain different hierarchies.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18230: The member identifier “string<\/i>” cannot be resolved.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The member identifier could not be resolved.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a valid member identifier.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18231: The StrToMember argument must be a member identifier when CONSTRAINED is specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The StrToMember argument was not a member identifier and CONSTRAINED was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Replace the argument with a member identifier or remove the CONSTRAINED option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18232: A set with the name “string<\/i>” has already been defined.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one set was defined with the same name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename the set so that it has a unique name within the WITH clause of the multidimensional expression (MDX) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18233: The set “string<\/i>” has a cycle.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The set definition referenced itself either directly or indirectly using another referenced set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the definition of the set so that it does not directly or indirectly refer to itself.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18234: The calculated member “string<\/i>” has the same name as an existing member.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name specified for the calculated member identified another member in the hierarchy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the name of the calculated member so that it is unique within the specified hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18235: The calculated member “string<\/i>” must be a member identifier qualified by hierarchy.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The calculated member identifier either was not a valid member identifier or does not contain a hierarchy qualification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the calculated member identifier so that it is a valid member identifier qualifying the hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18236: The calculated member “string<\/i>” has a cycle.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The calculated member referenced itself either directly or indirectly using another referenced calculated member.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the definition of the calculated member so that it does not directly or indirectly refer to itself.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18237: A calculated member with the name “string<\/i>” has already been defined.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0More than one calculated member was defined with the same name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rename the calculated member so that it has a unique name within the WITH clause of the multidimensional expression (MDX) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18250: The input parameter to the MDX PL\/SQL function is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input parameter to the PL\/SQL function was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the input parameter to the PL\/SQL function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18252: There are no active MDX queries.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either an MDX (MultiDimensional eXpression) query was not executed or all executed queries were closed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Execute an MDX (MultiDimensional eXpression) query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18253: invalid queryID:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MDX (MultiDimensional eXpression) query did not exist in the session with the given queryID.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid queryID obtained by calling dbms_mdx_odbo.execute.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18254: invalid cellRange size:\u00a0string<\/i>\u00a0given,\u00a0string<\/i>\u00a0expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The size of the cellRange sequence was not 2 times the number of axes.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a cellRange that has the correct number of elements.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18255: Invalid cellRange: start (string<\/i>) is greater than end (string<\/i>) for axis\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The start was greater than end for a particular axis in the cellRange.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify start less than or equal to end for each axis in the cellRange.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18256: Invalid axisIndex:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The axisIndex was out of range.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify an axisIndex greater than or equal to 0 and less than the number of axes.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18257: The classification value for “string<\/i>” for measure “string<\/i>” is invalid for MDX.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The classification value was invalid for MultiDimensional eXpression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Replace the Classification value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18258: The MDX Slicer contains more than one row.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The set defining the Slicer resulted in more than one row.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the Slicer portion of the MultiDimensional eXpression query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18259: The MDX Schema Rowset type request is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MDX (MultiDimensional eXpression) Schema Rowset type was not a valid value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Valid MDX (MultiDimensional eXpression) schema Rowset types are between 1 and 10.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18260: The MDX Schema Rowset Restrictions array and Empty array are not the same size.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The MultiDimensional eXpression Schema Rowset Restrictions array and the Empty array were not the same size.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the sizes of the Restriction and Empty arrays.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18261: The TREE_OP restriction value is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given TREE_OP restriction value was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a valid TREE_OP restriction value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18262: invalid empty value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A value in the given empty list was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a valid empty value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18263: invalid object name and log number combination<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object name and log number combination did not match the value returned by DBMS_HIERARCHY.VALIDATE_HIERARCHY or VALIDATE_CUBE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a valid combination of object name and log number and reexecute.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18264: The ‘queryProperties’ sequence has an invalid length.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ‘queryProperties’ sequence had an odd number of elements.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the ‘queryProperties’ sequence is either empty or contains an even number of elements.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18265: fact table key column (string<\/i>) with value (‘string<\/i>‘) not in dimension star table key column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a row in the fact table with a key column value that was not in the corresponding dimension star table key column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each fact table key column value has a corresponding row in the dimension star table key column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18266: analytic view key (string<\/i>) with value (‘string<\/i>‘) does not determine hierarchy lowest level key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute references found on the analytic view keys could not determine the level key column values of the lowest level in the hierarchy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the attribute references found on the analytic view keys determine the level key column values of the lowest level in the hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18267: key (string<\/i>) with value (string<\/i>) for level “string<\/i>” does not determine all level attributes<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There were rows with the level key column value where the number of distinct values of every attribute column and alternate key attribute were not zero or one.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of distinct values of every attribute column and alternate key attribute is zero or one for each level key column value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18268: alternate key (string<\/i>) with value (string<\/i>) for level “string<\/i>” does not determine level key column value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There were rows with the alternate key attribute that had non-unique level key values.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the alternate key attribute rows all have the same level key value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18269: key or alternate key attribute “string<\/i>” has\u00a0string<\/i>\u00a0NULL values<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A level key column value was defined as NULL when it should be NOT NULL.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not define a level key column value to NULL when it should be the NOT NULL value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18270: key or alternate key attributes “string<\/i>” and “string<\/i>” for level “string<\/i>” have\u00a0string<\/i>\u00a0mismatched NULL values<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a mismatch in the number of NULL values for a SKIP WHEN NULL level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that for each SKIP WHEN NULL level, either all level key column values and alternate key attributes are NULL, or all of the level key column values and alternate key attributes are not NULL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18271: invalid value for VisualMode query property<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-integer value, a negative value, or a value greater than 2 was specified for the VisualMode query property.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify an integer value of 0, 1, or 2 for the VisualMode query property.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18272: analytic view join key (string<\/i>) with value (‘string<\/i>‘) not unique in dimension star table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An analytic view join key did not determine all rows in the dimension star table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the analytic view join key determines all rows in the dimension star table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18273: analytic view does not contain cache<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a materialized view SQL statement for an analytic view that did not contain a cache.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the analytic view to contain a cache or specify an analytic view with a cache.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18274: invalid analytic view cache index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified analytic view cache index was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid cache index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18275: invalid column length in log table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column size of the table did not match with the default log table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the table provided has a correct column definition.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18276: invalid log table version, upgrade is required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a mismatch in the log table format that corresponds with an older version of the table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Call DBMS_HIERARCHY.UPGRADE_VALIDATE_LOG_TABLE in order to upgrade to the latest format and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18280: The REFERENCES clause for analytic view dimension “string<\/i>” is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The REFERENCES clause specified for the analytic view dimension was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the REFERENCES clause for the analytic view dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18281: cyclic reference detected for calculated measure “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cyclic reference for a calculated measure was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the cyclic reference for the calculated measure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18282: invalid join condition detected on join path “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid join condition was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each side of the join condition comes from a different source.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18283: invalid join path reference “string<\/i>” detected on hierarchy “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid join path reference was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the join path on the hierarchy refers to a join path on the attribute dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18284: invalid join paths detected on attribute dimension “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Invalid join paths were detected on the attribute dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that every dimension source is reachable starting with any source and applying join paths of the visited sources.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18285: invalid join paths detected on hierarchy “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Invalid join paths were detected on the hierarchy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that every join path contains a single unique path and includes every dim source of every level in the hierarchy exactly once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18286: invalid SKIP WHEN NULL specification on a calculation expression detected on hierarchy\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid SKIP WHEN NULL specification was detected on the calculation expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that SKIP WHEN NULL is only specified on skip level hierarchies.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18287: invalid level name “string<\/i>” detected on a calculation expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid level name specification was detected on the calculation expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the level exists on the hierarchy specified in the calculation expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18288: parent-child hierarchy “string<\/i>” detected on a calculation expression level specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A parent-child hierarchy was detected on the calculation expression level specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the level specifcation on the calculation expression does not reference a parent-child hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18289: parent-child member literal expression detected for level-based hierarchy\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A parent-child member literal expression was detected for a level-based hierarchy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the parent-child member literal expression is used with a parent-child hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18290: positional member key mismatch detected between member literal expression and hierarchy level “string<\/i>” on hierarchy “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of member keys on the member literal expression did not match those on the corresponding level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the number of member keys on the member literal expression match those on the corresponding level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18291: named member key mismatch detected between member literal expression and hierarchy level “string<\/i>” on hierarchy “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The member keys on the member literal expression did not match those on the corresponding level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the member keys on the member literal expression match those on the corresponding level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18294: invalid data type detected on attribute “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid data type was detected on an attribute.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the attributes are not of LOB, BFILE, or LONG data type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18295: duplicate hierarchy\u00a0string<\/i>\u00a0detected in a calculation expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The same cube hierarchy was named more than once in the calculation expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify each cube hierarchy only once in the calculation expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18296: ambiguously defined hierarchy\u00a0string<\/i>\u00a0detected in a calculation expression<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An ambiguously defined hierarchy was detected in a calculation expression.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resolve the ambiguity on the hierarchy used in the calculation expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18297: invalid data type detected on base measure “string<\/i>” for use with aggregation operator “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid data type was detected on a base measure for use with its specified aggregation operator.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the data type of the base measure is valid with the aggregation operator on the base measure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18298: The REFERENCES clause for the analytic view dimension “string<\/i>” does not determine the lowest level of every hierarchy.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The REFERENCES clause specified for the analytic view dimension was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the REFERENCES clause for the analytic view dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18299: level “string<\/i>“: data type of\u00a0string<\/i>\u00a0expression is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified hierarchical attribute of the specified level had an invalid data type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all attributes of the specified type are character expressions using the same character set.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18300: level “string<\/i>“: character set of\u00a0string<\/i>\u00a0expression does not match level “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified hierarchical attribute of the specified level used a character set that did not match the character set of other levels.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that all attributes of the specified type are character expressions using the same character set. An explicit ALL clause may need to be specified if the default character set of the ALL attributes does not match the character set used in other levels.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18301: attribute dimension “string<\/i>“.”string<\/i>” does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute dimension did not exist or the user did not have the required privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the spelling of the attribute dimension and ensure that the required privileges are granted.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18302: hierarchy “string<\/i>“.”string<\/i>” does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The hierarchy did not exist or the user did not have the required privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the spelling of the hierarchy and ensure that the required privileges are granted.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18303: The REFERENCES clause for the analytic view dimension “string<\/i>” refers to a level key where the level is marked as SKIP WHEN NULL.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The REFERENCES clause specified for the analytic view dimension was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the REFERENCES clause for the analytic view dimension or remove the SKIP WHEN NULL from the attribute dimension level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18304: non-measure “string<\/i>” reference in calculated measure “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-measure was referenced in a calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that only a measure is referenced in a calculated measure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18305: non-aggregation user-defined function “string<\/i>” detected in window calculated measure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-aggregation user-defined function was specified for a window calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that a valid user-defined aggregation function is specified for a window calculated measure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18306: invalid depth expression specified in a hier ancestor calculated measure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid depth expression was specified in a hier ancestor calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the depth expression of the hier ancestor evaluates to a positive integer no greater than the number of levels in the hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18307: analytic view “string<\/i>“.”string<\/i>” does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The analytic view did not exist or the user did not have the required privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the spelling of the analytic view and ensure that the required privileges are granted.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18310: The attribute dimension has no level specification.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute dimension did not have a level specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at least one level in the attribute dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18311: MATERIALIZED or DYNAMIC keyword is missing.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either the MATERIALIZED or DYNAMIC keyword was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the MATERIALIZED or DYNAMIC keyword for this level group.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18312: Dynamic caching is not enabled.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Analytic View (AV) dynamic caching initialization parameter was not set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable Dynamic AV caching using the appropriate initialization parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18340: Attribute “string<\/i>” referenced in a key on level “string<\/i>” does not exist.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The level key did not reference a valid attribute in the dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reference an existing attribute in the level key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18341: Determined attribute “string<\/i>” referenced on level “string<\/i>” does not exist.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The determined attribute did not reference a valid attribute in the dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reference an existing attribute in the level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18342: Level “string<\/i>” does not have a member name.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The level did not have a member name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a member name for this multi-attribute key level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18343: Default measure “string<\/i>” does not exist in the cube.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The default measure did not reference a valid measure in the cube.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reference an existing measure in the cube.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18344: Attribute “string<\/i>” cannot be named using a reserved word.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute was named using a reserved word.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a name for the attribute that is not a reserved word.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18345: Duplicate metadata object “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate metadata object was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove or rename the duplicate metadata object specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18346: Cube hierarchy “string<\/i>” cannot be set as the default.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Another default cube hierarchy was specified within the same cube dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set only one default cube hierarchy within a cube dimension.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18347: Duplicate level key “string<\/i>” was detected in level “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate level key was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove or replace the duplicate level key specification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18348: Invalid hierarchical attribute name “string<\/i>” specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The hierarchical attribute was named using an invalid word.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a valid name for the hierarchical attribute.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18349: Invalid skip level specification on attribute dimension “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The attribute dimension was defined with an invalid skip level specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0At least one level on the attribute dimension must be NOT NULL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18350: Attribute “string<\/i>” referenced on the ORDER BY clause on level “string<\/i>” does not exist.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ORDER BY attribute did not reference a valid attribute in the dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reference an existing attribute in the level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18351: Cyclic-determined attribute reference detected for level “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cyclic-determined attribute reference for a level was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the cyclic-determined attribute reference for the level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18352: Invalid expression “string<\/i>” detected on a calculated measure.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid expression was detected on a calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0An offset expression or member key expression cannot contain a column expression or be an analytic view SQL calculation expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18353: invalid ALL member name “string<\/i>” detected on a hierarchy dimension “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid ALL member name was detected on a hierarchy dimension.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the ALL member name is a constant expression.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18356: duplicate level name “string<\/i>” found in Cache Level List<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate level was found in the level list for an Analytic View Cache Level Group.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each Analytic View Cache Level Group contains a distinct list of levels.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18357: duplicate measure name in Cache Measure List “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate measure was found in the measure list for an Analytic View Cache Level Group.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each Analytic View Cache Level Group contains a distinct list of measures.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18358: Cache Level List hierarchy not found “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A hierarchy specified in the level list for an Analytic View Cache Level Group was not found.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each specified hierarchy in the Analytic View Cache Level Group is defined within the Analytic View.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18359: Cache Level List dimension not found “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A dimension specified in the level list for an Analytic View Cache Level Group was not found.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each specified dimension in the Analytic View Cache Level Group is defined within the Analytic View.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18360: duplicate hierarchy found in Cache Level List<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Multiple levels for the same hierarchy were found in the level list for an Analytic View Cache Level Group.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that each Analytic View Cache Level Group contains only one level per hierarchy.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18361: duplicate Cache Object found in Analytic View Cache<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A duplicate Analytic View Cache Level Group and Measure List combination was found in the Analytic View Cache.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that for each Measure List the Analytic View Cache Level Group Lists are unique.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18362: The level type of level “string<\/i>” is inconsistent with the dimension type.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The level type was inconsistent with the dimension type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure the level type is consistent with the dimension type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18363: Key “string<\/i>” is a subset of another key at level “string<\/i>“.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One key was a subset of another key at the same level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that no key is a subset of another key at the same level.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18364: invalid calculated measure clause “string<\/i>” detected in measure “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Invalid syntax was specified for a calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the syntax is correct.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18365: invalid aggregation function detected in window calculated measure “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid aggregation function was specified for a window calculated measure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that a valid aggregation function is specified for a window calculated measure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18370: The HIERARCHIES clause may only be specified for cubes.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A HIERARCHIES clause was used on a table or other non-cube object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the HIERARCHIES clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18371: invalid cube hierarchy qualification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cube hierarchies may only be qualified by dimension in the HIERARCHIES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the additional qualification.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18372: syntax error in HIERARCHIES list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal syntax was found in the HIERARCHIES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the HIERARCHIES clause only contains a comma delimited list of cube hierarchies enclosed in parentheses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18373: missing hierarchy name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No hierarchy was specified in the HIERARCHIES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify at least one hierarchy in the HIERARCHIES clause enclosed in parentheses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18374: duplicate hierarchies in HIERARCHIES clause<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The same cube hierarchy was named more than once in the HIERARCHIES clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify each cube hierarchy only once in the HIERARCHIES clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18375: Cube columns cannot be directly or indirectly referenced in ANSI named column joins.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cube column was referenced in an ANSI NATURAL JOIN or USING clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the ANSI ON clause or Oracle join syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18376: A hierarchy or analytic view is not allowed here.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A hierarchy or analytic view was specified in an incorrect location in a statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the name is correct or remove it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18377: Comments on columns of analytic view objects are not supported.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A comment for a column of an analytic view object was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not define comments for columns of analytic views. Use classifications instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18378: calculated measure “string<\/i>” in cache measure list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Calculated measures were not allowed in the cache measure list.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove calculated measures from the cache measure list.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18379: the query hint must start with “\/*+”<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal syntax was found in the query hint session parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the hint syntax provided is a valid SQL hint syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18380: the query hint must end with “*\/<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal syntax was found in the query hint session parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the hint syntax provided is a valid SQL hint syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-18381: the query hint cannot contain any occurrences of “*\/” within the text<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Illegal syntax was found in the query hint session parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the hint syntax provided is a valid SQL hint syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-19000: missing RELATIONAL keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Supply the RELATIONAL keyword in the storage clause<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-18200 to ORA-19000 ORA-18201: The input MDX string is empty. Cause:\u00a0The input MDX (MultiDimensional eXpression) string was empty. Action:\u00a0Correct the input MDX (MultiDimensional eXpression) string. ORA-18202: MDX parser error at line\u00a0string, column\u00a0string:\u00a0string. Cause:\u00a0The input MDX (MultiDimensional eXpression) query had invalid syntax. Action:\u00a0Correct the syntax error for…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2266","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-Ay","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2266"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2266\/revisions"}],"predecessor-version":[{"id":2267,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2266\/revisions\/2267"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2266"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}