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

NID-00311: Control File string - modified

1 Answers  


ORA-01138: database must either be open in this instance or not at all

2 Answers  


ORA-02066: missing or invalid DISPATCHERS text

1 Answers  


ORA-35071: (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.

1 Answers  


RMAN-08588: converted datafile=string

1 Answers  






ORA-09775: osnmrs: reset protocol error

1 Answers  


NNC-00400: memory exhausted

1 Answers  


ORA-26051: internal error parsing packed decimal format string

1 Answers  


NZE-28859: SSL negotiation failure

1 Answers  


DRG-10579: must provide text query criteria

1 Answers  


TNS-00115: Could not allocate pump global buffers

1 Answers  


ORA-01980: error during OS ROLE initialization

1 Answers  


Categories