{"id":1956,"date":"2016-05-08T11:39:23","date_gmt":"2016-05-08T08:39:23","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1956"},"modified":"2016-10-26T11:41:01","modified_gmt":"2016-10-26T08:41:01","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-18000-to-ora-18200","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-18000-to-ora-18200\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-18000 to ORA-18200"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-18000 to ORA-18200<\/strong><\/p>\n

\n
ORA-18000: invalid outline name<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The parser detected a missing or invalid outline name<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18001: no options specified for ALTER OUTLINE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The parser detected that no clause was specified on the command Our performance tests, which are not typical as they exercise all branches of the code, have shown approximately a 30% performance increase line for ALTER OUTLINE.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the command, specifying a valid ALTER OUTLINE clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18002: the specified outline does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either the outline did not exist to begin with, or a timing window allowed for another thread to drop or alter the outline midstream.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18003: an outline already exists with this signature<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The signature generation algorithm generates signatures that are are 16 bytes in length so it is highly unlikely that any 2 signatures will be identical. This message is raised in such a rare case.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either re-issue the statement that led to the outline being created with some whitespace added or force the outline to be created in a different category.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18004: outline already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An outline already exists, either with the specified name, or for the specified SQL text.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18008: cannot find OUTLN schema<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database creation script that creates this schema must not have been executed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Review the log files to see what happened when the database was created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18009: one or more outline system tables do not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either the database creation script that creates these tables was not executed or a user accidently deleted the table<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Review the log files to see what happened when the database was created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18010: command missing mandatory CATEGORY keyword<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User failed to specify the CATEGORY keyword<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the command with the CATEGORY keyword included<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18015: invalid source outline signature<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User imported an 8i outline into a 9i database without updating signatures<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0execute dbms_outln.update_signatures<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18100: XUST0001 – Updating expression in a wrong position<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An updating expression was used in a position other than one of the following:<\/span><\/span><\/span><\/dd>\n
– The topmost expression in the body of a query.<\/span><\/span><\/span><\/dd>\n
– The MODIFY clause of a TRANSFORM expression.<\/span><\/span><\/span><\/dd>\n
– The RETURN clause of a FLWOR expression.<\/span><\/span><\/span><\/dd>\n
– The RETURN clauses of a TYPESWITCH expression in which every RETURN clause contains an updating expression, an empty expression ( ), or a call to the fn:error function.<\/span><\/span><\/span><\/dd>\n
– The THEN and ELSE clauses of a conditional statement in which both the then and else clauses contain either an updating expression, an empty expression ( ), or a call to the fn:error function.<\/span><\/span><\/span><\/dd>\n
– An operand of a comma expression in which each operand is either an updating expression, an empty expression ( ), or a call to the fn:error function.<\/span><\/span><\/span><\/dd>\n
– The content of a parenthesized expression.<\/span><\/span><\/span><\/dd>\n
– The body of a function declaration in which the keyword UPDATING is specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-18101: XUST0002 – Non-updating expression in a wrong position<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A non-updating expression other than an empty expression ( ) or a call to the fn:error function was used in one of the following positions:<\/span><\/span><\/span><\/dd>\n
– The MODIFY clause of a TRANSFORM expression.<\/span><\/span><\/span><\/dd>\n
– The top-level expression in the body of a function declaration in which the keyword UPDATING is specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18102: XUST0003 – Repeated revalidation declaration<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Prolog contained more than one revalidation declaration.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18103: XUTY0004 – Invalid attribute node in the insertion sequence<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The insertion sequence of an INSERT expression contained an attribute following a node that was not an attribute node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18104: XUTY0005 – Invalid target expression for INSERT<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In an INSERT expression where INTO, AS FIRST INTO, or AS LAST INTO was specified, the target expression returned a nonempty result that did not consist of a single element or document node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18105: XUTY0006 – Invalid target expression for INSERT<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In an INSERT expression where BEFORE or AFTER was specified, the target expression returned a nonempty result that did not consist element, text, comment, or processing instruction node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18106: XUTY0007 – Invalid target expression for DELETE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The target expression of a DELETE expression did not return a sequence of zero or more nodes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18107: XUTY0008 – Invalid target expression for REPLACE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a REPLACE expression, the target expression returned a nonempty result that did not consist of a single element, attribute, text,<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18108: XUDY0009 – Invalid target expression for REPLACE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a REPLACE expression where VALUE OF was not specified, the node returned by the target expression did not have a parent.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18109: XUTY0010 – Invalid replacement sequence for REPLACE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a REPLACE expression where VALUE OF was not specified and the target was an element, text, comment, or processing instruction node, the replacement sequence did not consist of zero or more element, text, comment, or processing instruction nodes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18110: XUTY0011 – Invalid replacement sequence for REPLACE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a REPLACE expression where VALUE OF was not specified and the target is an attribute node, the replacement sequence did not consist of zero or more attribute nodes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18111: XUTY0012 – Invalid target expression for RENAME<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a RENAME expression, the target expression returned a nonempty result that did not consist of a single element, attribute, or processing instruction node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18112: XUTY0013 – Invalid COPY expression for TRANSFORM<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a TRANSFORM expression, a source expression in the copy clause did not return a single node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18113: XUDY0014 – Modified node was not created by the COPY clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In a TRANSFORM expression, the MODIFY clause modified a node that was not created by the COPY clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18114: XUDY0015 – Duplicate RENAME for the same target node<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A node was the target of more than one RENAME expression within the same query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18115: XUDY0016 – Duplicate REPLACE for the same target node<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A node was the target of more than one REPLACE expression (without VALUE OF being specified) within the same query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18116: XUDY0017 – Duplicate REPLACE for the same target node<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A node was the target of more than one REPLACE VALUE OF expression within the same query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18117: XUDY0018 – External not updating function returns an updated value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A function that was declared to be external but not updating returned a nonempty pending update list.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18118: XUDY0019 – External updating function returns an invalid value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A function that was declared to be both external and updating returned a nonempty data model instance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18119: XUDY0020 – Deleted node has no parent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Node was deleted that had no parent before execution of the query began.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18120: XUDY0021 – The result XDM instance violates XDM constraints<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0XDM instance resulting from applying all the updates in a query violated constraint specified in [XQuery\/XPath Data Model (XDM)]. In this case, none of the updates in the query were made effective.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18121: XUTY0022 – Invalid attribute insertion into a document node<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0INSERT expression specified the insertion of an attribute node into a document node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18122: XUDY0023 – Updating expression introduces a namespace conflict<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An INSERT, REPLACE, or RENAME expression affected an element node by introducing a new namespace binding that conflicted with one of its existing namespace bindings.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18123: XUDY0024 – Updating expression introduces a namespace conflict<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Effect of a set of updating expressions introduced conflicting namespace bindings into an element node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18124: XUDY0025 – Invalid QName for processing instruction RENAME<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Target of a RENAME expression was a processing instruction node, and the new name expression returned a QName with a nonempty namespace prefix.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18125: XUST0026 Revalidation mode\u00a0string<\/i>\u00a0is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Revalidation declaration in a Prolog specified a revalidation mode that is not supported by the current implementation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18126: XUDY0027 – Invalid target expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Target expression of an INSERT, REPLACE, or RENAME expression evaluated to an empty sequence.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18127: XUST0028 – Updating function should not have a return type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function declaration specified both UPDATING and a return type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18128: XUDY0029 – INSERT expression target node doesn’t have a parent<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In an INSERT expression where BEFORE or AFTER was specified, a node returned by the target expression did not have a parent.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18129: XUDY0030 – Invalid insertion of an attribute node<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0INSERT expression specified the insertion of an attribute node before or after a child of a document node.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18130: FOUP0001 – Invalid ‘fn:put’ first operand<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The first operand of fn:put was not a node of a supported kind.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18131: FOUP0002 – Invalid ‘fn:put’ second operand<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The second operand of fn:put was not a valid lexical representation of the xs:anyURI type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18150: SQL input value cannot be modified in updating expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Updating expression was specified as top-level XMLQuery expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use XQuery TRANSFORM expression to copy input value and modify it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18160: FTST0001 – FTMildNot operator not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use the mild not option when the FTMildNot operator was not supported. An implementation that does not support the FTMildNot operator must raise a static error if a full-text query contains a mild not.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTMildNot full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18161: FTST0002 – FTUnaryNot operator not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that enforces one of the restrictions on FTUnaryNot must raise a static error if a full-text query does not obey the restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTUnaryNot full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18162: FTST0003 – FTUnit and FTBigUnit not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that does not support one or more of the choices on FTUnit and FTBigUnit must raise a static error if a full-text query contains one of those choices.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTUnit or FTBigUnit option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18163: FTST0004 – FTScope not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that does not support the FTScope operator must raise a static error if a full-text query contains a scope.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTScope full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18164: FTST0005 FTTimes not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that does not support the FTTimes operator must raise a static error if a full-text query contains a times.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTTimes full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18165: FTST0006 FTStopwordOption not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that restricts the use of FTStopwordOption must raise a static error if a full-text query contains a stop word option that does not meet the restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTStopwordOption full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18166: FTST0007 FTIgnoreOption not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that restricts the use of FTIgnoreOption must raise a static error if a full-text query contains an ignore option that does not meet the restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTIgnoreOption full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18167: FTST0008 stop word list not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a static error if, during the static analysis phase, the query is found to contain a stop word option that refers to a stop word list that is not found in the statically known stop word lists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Please make sure the stop word list exist.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18168: FTST0009 language option not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It may be a static error if, during the static analysis phase, the query is found to contain a language identifier in a language option that the implementation does not support. The implementation may choose not to raise this error and instead provide some other implementation-defined behavior.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the language full-text query option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18169: FTST0010 FTOrder not succeeding FTWindow or FTDistance operator<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a static error if, during the static analysis phase, an expression is found to use an FTOrder operator that does not appear directly succeeding an FTWindow or an FTDistance operator and the implementation enforces this restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use the FTOrder succeeding FTWindow or FTDistance full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18170: FTST0011 FTWindow and FTDistance restriction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation may restrict the use of FTWindow and FTDistance to an FTOr that is either a single FTWords or a combination of FTWords involving only the operators && and ||. If it a static error if, during the static analysis phase, an expression is found that violates this restriction and the implementation enforces this restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Follow FTWindow and FTDistance restriction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18171: FTST0012 FTContent not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation that does not support the FTContent operator must raise a static error if a full-text query contains one.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use FTContent full-text query operator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18172: FTST0013 more than one language encountered<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a static error if, during the static analysis phase, an implementation that restricts the use of FTLanguageOption to a single language, encounters more than one distinct language option.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use more than one language in FTLanguag full-text option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18173: FTST0014 score computation restriction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An implementation may constrain the form of the expression used to compute scores. It is a static error if, during the static analysis phase, such an implementation encounters a scoring expression that does not meet the restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18174: FTST0015 FTCaseOption restriction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a static error if, during the static analysis phase, an implementation that restricts the choices of FTCaseOption encounters the “lowercase” or “uppercase” option.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18175: FTDY0016 weights invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a dynamic error if an implementation that does not support negative weights encounters a weight expression that does not meet the restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use invalid weights value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-18176: FTDY0017 mild not selection containings StringExclude<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is a dynamic error if an implementation encounters a mild not selection, one of whose operands evaluates to an AllMatches that contains a StringExclude<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-18000 to ORA-18200 ORA-18000: invalid outline name Cause:\u00a0The parser detected a missing or invalid outline name Action:\u00a0None ORA-18001: no options specified for ALTER OUTLINE Cause:\u00a0The parser detected that no clause was specified on the command Our performance tests, which are not typical as they exercise all branches…<\/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":[14,32,54],"class_list":["post-1956","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-vy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1956","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=1956"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1956\/revisions"}],"predecessor-version":[{"id":1957,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1956\/revisions\/1957"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1956"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}