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-09206: sfrfb: error reading from file

1 Answers  


ORA-08275: Environment variable unset

1 Answers  


ORA-12630: Native service operation not supported

1 Answers  


IMG-00585: output format does not support the specified channelOrder

1 Answers  


ORA-15109: conflicting protection attributes specified

1 Answers  






PCC-00072: Input file name length exceeds the maximum length

1 Answers  


PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

1 Answers  


DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 Answers  


ORA-27212: some entrypoints in Media Management Library are missing

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  


ORA-01503: CREATE CONTROLFILE failed

1 Answers  


LSX-00202: contents of "~S" should be text only

1 Answers  


Categories