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
3090 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

PROC-00029: Error in logging layer

1 Answers

RMAN-06170: no controlfile copy found with offline range recid string stamp string datafile string

1 Answers

NCR-03020: NCRO: Invalid call context

1 Answers

ORA-22950: cannot ORDER objects without MAP or ORDER method

1 Answers

TNS-01041: %s parameter "string" set to string

1 Answers

PLS-00563: illegal use of CAST expression

1 Answers

NNO-00300: no listen addresses specified, at least one is required

1 Answers

ORA-12550: TNS:syntax error

1 Answers

ORA-22634: Error adding new instance to AnyDataSet

1 Answers

ORA-29263: HTTP protocol error

1 Answers

ORA-16796: One or more properties could not be imported from the database.

2 Answers

ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.

1 Answers

For more Oracle Errors Interview Questions Click Here