ORA-01716: NOSORT may not be used with a cluster index



ORA-01716: NOSORT may not be used with a cluster index..

Answer / guest

Cause: An attempt was made to create a cluster index using
the NOSORT option.

Action: Remove NOSORT from the CREATE INDEX statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06120: NETTCP: network driver not loaded

1 Answers  


ORA-27146: post/wait initialization failed

1 Answers  


PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements

1 Answers  


QSM-00776: the user-defined workload string is missing the following column: string

1 Answers  


ORA-27036: translation error, unable to expand file name

1 Answers  






ORA-29553: class in use: string.string

1 Answers  


ORA-01173: data dictionary indicates missing data file from system tablespace

1 Answers  


ORA-13192: failed to read number of element rows

1 Answers  


TNS-04014: Current instance string is already started

1 Answers  


ORA-10573: Test recovery tested redo from change string to string

1 Answers  


ORA-12071: definition query of "string"."string" is invalid for offline instantiation

1 Answers  


ORA-24022: the specified parameters has no effect on the queue

1 Answers  


Categories