Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers  


PLS-00901: the data type of column 'string' of table 'string' is not supported

1 Answers  


LPX-00321: None of the output method (DOM, SAX, Stream) is selected

1 Answers  


ORA-19709: numeric parameter must be non-negative integer

1 Answers  


ORA-32761: Turn off Temp LOB Ref Count Feature

1 Answers  






ORA-02761: File number to be canceled is negative.

1 Answers  


SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  


ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page

1 Answers  


DRG-50610: internal error: string

1 Answers  


ORA-31087: insufficient privileges to delete schema "string"

1 Answers  


IMG-00921: threshold out of range

1 Answers  


RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

1 Answers  






Categories