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-02169: FREELISTS storage option not allowed

1 Answers  


ORA-12674: Shared server: proxy context not saved

1 Answers  


NMP-00005: general SNMP error

1 Answers  


ORA-13753: "SQL Tuning Set" "string" already exists.

1 Answers  


RMAN-07521: cannot create recovery catalog in database version string; version string required

1 Answers  






ORA-02495: cannot resize file string, tablespace string is read only

1 Answers  


ORA-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  


PLS-01469: ANSI standard does not permit records

1 Answers  


NNL-00278: Maximum number of times a request can be reforwarded is now number

1 Answers  


ORA-12985: tablespace 'string' is read only, cannot drop column

1 Answers  


ORA-12556: TNS:no caller

1 Answers  


DRG-51201: failed to perform DDL operation: database object string

1 Answers  


Categories