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-00910: insufficient privilege to inherit from type string

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-29816: object being disassociated is not present

1 Answers  


TNS-00265: Navigator: Reloaded network configuration data

1 Answers  


ORA-28028: could not authenticate remote server

1 Answers  






TNS-00309: Connection Manager: Failed to open log while re-reading parameter data

1 Answers  


DRG-10753: invalid memory size string string

1 Answers  


ORA-25462: evaluation context not specified

1 Answers  


RMAN-08114: channel string: restoring SPFILE to PFILE

1 Answers  


IMG-00807: no weights specified in weight string

1 Answers  


PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."

1 Answers  


ORA-02877: smpini: Unable to initialize memory protection

1 Answers  


Categories