PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be
used with the same function argument



PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument..

Answer / guest

Cause: PARTITION-BY and CLUSTER/ORDER-BY clauses are
specified on different function arguments.

Action: Use the same argument in both PARITITON-BY and
CLUSTER/ORDER-BY clauses.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02047: window function in mv

1 Answers  


ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

1 Answers  


ORA-13339: LRS polygon clipping across multiple rings

1 Answers  


ORA-12997: cannot drop primary key column from an index-organized table

1 Answers  


ORA-01162: block size string in file header does not match configured block sizes

1 Answers  






RMAN-06558: archived log size of number kb is bigger than available space of number kb

1 Answers  


TNS-01171: Event detection broke for dispatcher: string

1 Answers  


ORA-27463: invalid program type string

1 Answers  


PLS-00101: reserved for future use

1 Answers  


ORA-25959: join index must be of the bitmap type

1 Answers  


ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option

1 Answers  


RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

1 Answers  


Categories