Thursday 17 May 2012

ORA-29964: missing ADD or DROP keyword

ORA-29964: missing ADD or DROP keyword

Cause: One of the keywords ADD or DROP is expected.

Action: Specify the ADD or DROP keyword or check the SQL statement.

ORA-29963: missing BINDING keyword

ORA-29963: missing BINDING keyword

Cause: Keyword BINDING is expected .

Action: Specify the BINDING keyword or check the SQL statement.

ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

Cause: Failed to successfully execute the ODCIIndexAlter routine.

Action: Check to see if the routine has been coded correctly.

ORA-29961: too many warnings occurred in the execution of ODCIIndex DDL routine

ORA-29961: too many warnings occurred in the execution of ODCIIndex DDL routine

Cause: The number of warnings during the ODCIIndex DDL routine is too high.

Action: Query table SYS.ODCI_WARNINGS$ to get more warning messages

ORA-29960: line string, string

ORA-29960: line string, string

Cause: The ODCIIndex DDL routine has put a warning message into table SYS.ODCI_WARNINGS$

Action: Check the warning message

ORA-29959: error in the execution of the string routine for one or more of the index partitions

ORA-29959: error in the execution of the string routine for one or more of the index partitions

Cause: An error occurred during execution of the routine for one or more of the index partitions

Action: Check the *_IND_PARTITIONS view to see which partitions are marked FAILED. Rebuild or Truncate the FAILED index partitions

ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

Cause: Failed to successfully execute the ODCIIndexCreate routine.

Action: Check to see if the routine has been coded correctly.

ORA-29957: cannot create a function-based domain index on a string table

ORA-29957: cannot create a function-based domain index on a string table

Cause: User specified an unsupported create function-based domain index statement.

Action: Issue the create function-based domain index statement only on supported types of tables.

ORA-29956: warning in the execution of ODCIINDEXEXCHANGEPARTITION routine

ORA-29956: warning in the execution of ODCIINDEXEXCHANGEPARTITION routine

Cause: A warning was returned from the ODCIIndexExchangePartition routine.

Action: Check to see if the routine has been coded correctly Check user specified log tables for greater detail.

ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

Cause: Failed to successfully execute the ODCIIndexExchangePartition routine.

Action: Check to see if the routine has been coded correctly.

ORA-29954: domain index partition is marked LOADING or FAILED or UNUSABLE

ORA-29954: domain index partition is marked LOADING or FAILED or UNUSABLE

Cause: An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

Action: Wait if the specified index partition is marked LOADING Rebuild the specified index partition if it is marked FAILED or UNUSABLE.

ORA-29953: cannot issue DDL on a domain index partition marked as FAILED

ORA-29953: cannot issue DDL on a domain index partition marked as FAILED

Cause: Tried to issue a DROP or ALTER on a domain index partition in a FAILED state.

Action: do ALTER INDEX REBUILD PARTITION to rebuild the index partition OR ALTER TABLE TRUNCATE PARTITION to mark the index partition as valid.

ORA-29952: cannot issue DDL on a domain index partition marked as LOADING

ORA-29952: cannot issue DDL on a domain index partition marked as LOADING

Cause: Tried to issue a DROP or ALTER or TRUNCATE on a domain index partition in a LOADING state.

Action: Wait till the index partition operation completes OR issue a DROP INDEX FORCE to drop the index OR issue a ALTER TABLE DROP PARTITION to drop the partition.

ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

Cause: A warning was returned from the ODCIIndexSplitPartition routine.

Action: Check to see if the routine has been coded correctly Check user specified log tables for greater detail.

ORA-29950: warning in the execution of ODCIINDEXMERGEPARTITION routine

ORA-29950: warning in the execution of ODCIINDEXMERGEPARTITION routine

Cause: A warning was returned from the ODCIIndexMergePartition routine.

Action: Check to see if the routine has been coded correctly Check user specified log tables for greater detail.

ORA-29936: NULL association is allowed only with a column or an index

ORA-29936: NULL association is allowed only with a column or an index

Cause: User tried to use the ASSOCIATE command with a schema object other than a column or an index

Action: Specify the NULL clause only with a column or an index

ORA-29935: missing FROM keyword

ORA-29935: missing FROM keyword

Cause: The keyword FROM is missing.

Action: Specify the FROM keyword or check the SQL statement.

ORA-29934: index specified for association is not a domain index

ORA-29934: index specified for association is not a domain index

Cause: The user issued an ASSOCIATE STATISTICS command with an index which is not a domain index.

Action: Issue an ASSOCIATE STATISTICS WITH INDEXES command on a domain index only

ORA-29933: object being disassociated has some user defined statistics stored

ORA-29933: object being disassociated has some user defined statistics stored

Cause: There are some user defined statistics collected for the object being disassociated.

Action: First delete the user defined statistics and then reissue the DISASSOCIATE command or specify the FORCE option with DISASSOCIATE.

ORA-29932: the type being dropped is a statistics type

ORA-29932: the type being dropped is a statistics type

Cause: Some objects have defined their statistics methods in the type being dropped.

Action: First drop the relevant associations using the DISASSOCIATE command and then retry the DROP command, or use the FORCE option with DROP TYPE command.

ORA-29931: specified association does not exist

ORA-29931: specified association does not exist

Cause: One or more of the object(s) that have been specified to be disassociated, do not have an association defined for them.

Action: Verify the objects which have an association defined and issue the disassociate command again.

ORA-29930: COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause

ORA-29930: COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause

Cause: The COMPUTE ANCILLARY DATA option was specified without the WITH INDEX CONTEXT clause.

Action: Specify the WITH INDEX CONTEXT option.

ORA-29929: missing SCAN Keyword

ORA-29929: missing SCAN Keyword

Cause: The scan context is not specified.

Action: Supply the SCAN keyword.

ORA-29928: duplicate default selectivity specified

ORA-29928: duplicate default selectivity specified

Cause: The keyword DEFAULT SELECTIVITY can only be specified once.

Action: Remove the duplicate keyword.

ORA-29927: error in executing the ODCIStatsCollect or ODCIStatsDelete routine

ORA-29927: error in executing the ODCIStatsCollect or ODCIStatsDelete routine

Cause: The ODCIStatsCollect or ODCIStatsDelete function is causing an error.

Action: Check the ODCIStatsCollect or ODCIStatsDelete function.

ORA-29926: association already defined for the object

ORA-29926: association already defined for the object

Cause: The object for which the association is being defined, already has a statistics type associated with it.

Action: Disassociate the object and then associate the object.

ORA-29925: cannot execute string

ORA-29925: cannot execute string

Cause: The specified function does not exist or does not have an appropriate signature.

Action: Implement the function with the appropriate signature.

ORA-29918: cannot create domain indexes on temporary tables

ORA-29918: cannot create domain indexes on temporary tables

Cause: An attempt was made to create a domain index on a temporary table

Action: Either create another type of index on the temporary table or change the table from temporary to a permanent table

ORA-29917: cannot lock a table which gets its rows from a collection operand

ORA-29917: cannot lock a table which gets its rows from a collection operand

Cause: Tables which gets its rows from a collection operand cannot be locked

Action: Don t lock the table

ORA-29915: cannot select FOR UPDATE from collection operand

ORA-29915: cannot select FOR UPDATE from collection operand

Cause: Collection operands cannot be updated

Action: Remove FOR UPDATE clause

ORA-29914: ODCIGETINTERFACES routine does not return required stream version

ORA-29914: ODCIGETINTERFACES routine does not return required stream version

Cause: The ODCIObjectList returned by the ODCIGetInterfaces routine does not contain the required stream version for external tables.

Action: Ensure that the ODCIGetInterfaces routine returns the required stream version.

ORA-29913: error in executing string callout

ORA-29913: error in executing string callout

Cause: The execution of the specified callout caused an error.

Action: Examine the error messages take appropriate action.

ORA-29911: null scan context returned by ODCIIndexStart() routine

ORA-29911: null scan context returned by ODCIIndexStart() routine

Cause: The ODCIIndexStart() routine returned a null scan context

Action: Ensure that the ODCIIndexStart() routine returns a non-null scan context.

ORA-29910: invalid callback operation

ORA-29910: invalid callback operation

Cause: Encountered an invalid callback operation.

Action: Ensure that all the callbacks executed from callouts are valid in the statement context.

ORA-29909: label for the ancillary operator is not a literal number

ORA-29909: label for the ancillary operator is not a literal number

Cause: The label used for invoking the ancillary operator is not a literal number.

Action: Use a literal number as the label.

ORA-29908: missing primary invocation for ancillary operator

ORA-29908: missing primary invocation for ancillary operator

Cause: The primary invocation corresponding to an ancillary operator is missing.

Action: Add the primary invocation with the same label as the ancillary operator.

ORA-29907: found duplicate labels in primary invocations

ORA-29907: found duplicate labels in primary invocations

Cause: There are multiple primary invocations of operators with the same number as the label.

Action: Use distinct labels in primary invocations.

ORA-29906: indextype string.string does not exist

ORA-29906: indextype string.string does not exist

Cause: The indextype does not exist.

Action: Create the indextype.

ORA-29905: method string does not exist in type string.string

ORA-29905: method string does not exist in type string.string

Cause: A required method with the required signature does not exist in the specified type.

Action: Add the required method to the type.

ORA-29904: error in executing ODCIIndexClose() routine

ORA-29904: error in executing ODCIIndexClose() routine

Cause: The execution of ODCIIndexClose routine caused an error.

Action: Examine the error messages produced by the indextype code and take appropriate action.

ORA-29903: error in executing ODCIIndexFetch() routine

ORA-29903: error in executing ODCIIndexFetch() routine

Cause: The execution of ODCIIndexFetch routine caused an error.

Action: Examine the error messages produced by the indextype code and take appropriate action.

ORA-29902: error in executing ODCIIndexStart() routine

ORA-29902: error in executing ODCIIndexStart() routine

Cause: The execution of ODCIIndexStart routine caused an error.

Action: Examine the error messages produced by the indextype code and take appropriate action.

ORA-29901: function underlying operator binding does not exist

ORA-29901: function underlying operator binding does not exist

Cause: The function underlying the operator binding does not exist.

Action: Ensure that the function corresponding to the operator invocation exists.

ORA-29900: operator binding does not exist

ORA-29900: operator binding does not exist

Cause: There is no binding for the current usage of the operator.

Action: Change the operator arguments to match any of the existing bindings or add a new binding to the operator.

ORA-29896: Length of PARAMETER string longer than string characters

ORA-29896: Length of PARAMETER string longer than string characters

Cause: An attempt was made to specify a parameter value that is longer than the allowed maximum.

Action: Reduce the parameter value length.

ORA-29895: duplicate base datatype specified

ORA-29895: duplicate base datatype specified

Cause: User attempted to add a base datatype to an indextype with ARRAY DML which is already supported by the indextype

Action: Remove the duplicate base datatype and retry the command

ORA-29894: base or varray datatype does not exist

ORA-29894: base or varray datatype does not exist

Cause: One of the base and varray datatypes specified in WITH ARRAY DML (DATA_TYPE, VARRAY_TYPE) clause could not be found.

Action: Check to see if the datatype exists and the user has EXECUTE privilege on this datatype.

ORA-29893: indextypes without column data do not need the given data type

ORA-29893: indextypes without column data do not need the given data type

Cause: WITH ARRAY DML (DATA_TYPE, VARRAY_TYPE) option and WITHOUT COLUMN DATA option conflicted in an alter indextype statement

Action: Reissue the ALTER INDEXTYPE statement without the conflict.

ORA-29892: indextypes with array DML do not support the given data type

ORA-29892: indextypes with array DML do not support the given data type

Cause: The user specified a REF or a LONG datatype which is not supported in CREATE or ALTER INDEXTYPE WITH ARRAY DML (DATA_TYPE, VARRAY_ TYPE).

Action: Reissue the CREATE or ALTER INDEXTYPE statement without the REF or LONG datatype.

ORA-29890: specified primary operator does not have an index context

ORA-29890: specified primary operator does not have an index context

Cause: The primary operator does not have an index and scan contexts.

Action: Create the primary operator with a context clause. NLS_DO_NOT_ TRANSLATE(29891,29891(

ORA-29888: cannot create domain index on a table with row movement enabled

ORA-29888: cannot create domain index on a table with row movement enabled

Cause: A create domain index statement was issued on a table that has row movement enabled.

Action: Disable the row movement in the table and then reissue the create domain index statement. NLS_DO_NOT_TRANSLATE(29889,29889(

ORA-29887: cannot support row movement if domain index defined on table

ORA-29887: cannot support row movement if domain index defined on table

Cause: An ALTER TABLE ENABLE ROW MOVEMENT was issued on a table which has a domain index defined on it.

Action: Drop the domain index if you want to enable row movement and then reissue the command.

ORA-29886: feature not supported for domain indexes

ORA-29886: feature not supported for domain indexes

Cause: Feature is not supported for domain indexes.

Action: No action required.

ORA-29885: domain index is defined on the column to be modified

ORA-29885: domain index is defined on the column to be modified

Cause: An ALTER TABLE MODIFY COLUMN was issued on a column on which a domain index exists.

Action: Drop the domain index before attempting to modify the column.

ORA-29884: domain index is defined on the column to be dropped

ORA-29884: domain index is defined on the column to be dropped

Cause: An ALTER TABLE DROP COLUMN was issued on a column on which a domain index exists.

Action: Drop the domain index before attempting to drop the column.

ORA-29883: cannot create a domain index on column expressions

ORA-29883: cannot create a domain index on column expressions

Cause: User specified an expression in the column list.

Action: Specify only simple columns in the column list for domain index.

ORA-29882: insufficient privileges to execute indextype

ORA-29882: insufficient privileges to execute indextype

Cause: User does not have privileges to execute the indextype.

Action: The owner of the indextype must grant appropriate privileges to the user.

ORA-29881: failed to validate indextype

ORA-29881: failed to validate indextype

Cause: Indextype cannot be compiled.

Action: Try to compile the indextype which is referenced by the domain index.

ORA-29880: such column list already indexed using another domain index and indextype

ORA-29880: such column list already indexed using another domain index and indextype

Cause: An attempt was made to create multiple domain indexes on a column list using indextypes which do not have disjoint operators.

Action: Check to see if the operator sets for the indextypes can be made disjoint.

ORA-29879: cannot create multiple domain indexes on a column list using same indextype

ORA-29879: cannot create multiple domain indexes on a column list using same indextype

Cause: An attempt was made to define multiple domain indexes on the same column list using identical indextypes.

Action: Check to see if a different indextype can be used or if the index can be defined on another column list.