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

PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  


ORA-16813: apply service not running on the apply instance string recorded by the broker

1 Answers  


RMAN-06534: KEEP ... CONSISTENT option is not supported

1 Answers  


IMP-00019: row rejected due to ORACLE error number

1 Answers  


ORA-02227: invalid cluster name

1 Answers  






QSM-02129: join or filter condition(s) are complex

1 Answers  


ORA-39004: invalid state

1 Answers  


RMAN-05007: no channel allocated

1 Answers  


DRG-11824: Method Not Allowed

1 Answers  


ORA-00131: network protocol does not support registration 'string'

1 Answers  


NZE-29178: certificate serial number is in CRL

1 Answers  


ORA-38478: creation of system trigger EXPFIL_DROPOBJ_MAINT failed

1 Answers  


Categories