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

NID-00371: Change database name of database string to string? (Y/[N]) =>

1 Answers  


EXP-00062: invalid source statements for an object type

1 Answers  


ORA-14317: cannot drop the last value of partition

1 Answers  


ORA-06561: given statement is not supported by package DBMS_SQL

1 Answers  


RMAN-03032: this option of set command needs to be used outside of a run block

1 Answers  






DRG-50931: parser not opened

1 Answers  


ORA-00209: control file blocksize mismatch, check alert log for more info

1 Answers  


ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-38443: An attribute set should be assigned to the expression set for statistics collection.

1 Answers  


ORA-39504: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


ORA-32052: failed to start mapping service

1 Answers  


DRG-10525: missing REBUILD keyword

1 Answers  


Categories