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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

1 Answers  


ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views

1 Answers  


SQL*Loader-00821: switching to GENERATE_ONLY

1 Answers  


RMAN-20250: offline range not found in the recovery catalog

1 Answers  


KUP-04020: found record longer than buffer size supported, number, in string

1 Answers  






TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


LPX-00220: the string "]]>" cannot occur in character data

1 Answers  


DGM-16900: Unable to initialize client

1 Answers  


ORA-22613: buflen does not match the size of the scalar

1 Answers  


DRG-11803: OK

1 Answers  


ORA-02089: COMMIT is not allowed in a subordinate session

1 Answers   Oracle,


Categories