PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only
with PARALLEL_ENABLE



PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE..

Answer / guest

Cause: User tried partion by order by cluster by without
parallel enable clause in table function.

Action: specify parallel enable also when using partion by,
cluster by order 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

PCC-01510: No Package, Procedure or Function statement seen in string

1 Answers  


TNS-00034: INTCTL: internal NR error

1 Answers  


ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.

1 Answers  


KUP-03018: invalid date mask "string" specified for column string

1 Answers  


NNL-00536: set|show requests_enabled [<on|off>] [<server_list>] : enable, disable or show server request processing

1 Answers  






ORA-02426: privilege grant failed

1 Answers  


O2F-00338: Illegal or missing package name

1 Answers  


ORA-02793: Close of asynchronous I/O failed.

1 Answers  


ORA-15048: ASM internal files cannot be deleted

1 Answers  


RMAN-06556: datafile string must be restored from backup older than scn string

1 Answers  


EXP-00029: Incremental export mode and consistent mode are not compatible

1 Answers  


ORA-19626: backup set type is string - can not be processed by this conversation

1 Answers  


Categories