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

Question Posted / guest

1 Answers
3063 Views
I also Faced
E-Mail Answers

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

NNC-00407: alias loop in name request

1 Answers

TNS-00284: Imm Max Avg Bytes/Sec : number

1 Answers

ORA-06144: NETTCP: SID (database) is unavailable

1 Answers

ORA-38469: invalid privilege for an expression set: string

1 Answers

DRG-13300: document size bigger than string bytes

1 Answers

NZE-28820: Signature or decryption/encryption state is not provided.

1 Answers

ORA-01120: cannot remove online database file string

1 Answers

ORA-25121: MINIMUM EXTENT value greater than maximum extent size

1 Answers

SQL*Loader-00620: Initial enclosure character not found

1 Answers

ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory

1 Answers

DRG-12232: invalid attribute tag format

1 Answers

DRG-10100: invalid argument found: string

1 Answers

For more Oracle Errors Interview Questions Click Here