PLS-00665: ORDER BY and CLUSTER BY clauses require a
PARTITION BY clause



PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause..

Answer / guest

Cause: An attempt was made to specify an ORDER BY or CLUSTER
BY clause without also specifying a PARTITION BY clause.

Action: Add a PARTITION BY clause, or remove the ORDER BY or
CLUSTER BY clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27479: Cannot string "string.string" because other objects depend on it

1 Answers  


TNS-01021: ------------------------

1 Answers  


IMG-00872: unsupported image model

1 Answers  


SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 Answers  


ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  






ORA-09797: Failed to get O/S MAC privileges.

1 Answers  


RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

1 Answers  


ORA-13909: Invalid combination of threshold value and operator.

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


ORA-13192: failed to read number of element rows

1 Answers  


ORA-30770: Cannot specify storage options for fixed size opaque type

1 Answers  


ORA-25131: cannot modify unique(string) - unique key not defined for table

1 Answers  


Categories