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-00514: INSERT statement with REF INTO clause requires a typed table

1 Answers  


NNL-00288: No cache flush currently scheduled

1 Answers  


ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

1 Answers  


ORA-24347: Warning of a NULL column in an aggregate function

1 Answers  


ORA-31497: invalid value specified for first_scn

1 Answers  


ORA-01251: Unknown File Header Version read for file number string

1 Answers  


ORA-28668: cannot reference mapping table of an index-organized table

1 Answers  


LSX-00165: content type of "~S" must be simple type

1 Answers  


TNS-12591: TNS:event signal failure

1 Answers  


SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


ORA-06044: NETDNT: connect failed, byte count quota exceeded

1 Answers  


ORA-06537: OUT bind variable bound to an IN position

1 Answers  


Categories