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-01653: unable to extend table string.string by string in tablespace string

1 Answers  


ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.

1 Answers  


ORA-30086: interval year-month result not allowed for datetime subtraction

1 Answers  


ORA-24159: invalid variable definiton

1 Answers  


ORA-30188: reserved for future use

1 Answers  






ORA-25462: evaluation context not specified

1 Answers  


ORA-12162: TNS:net service name is incorrectly specified

1 Answers  


ORA-39958: invalid warning category qualifier

1 Answers  


ORA-01099: cannot mount database in SHARED mode if started in single process mode

1 Answers  


ORA-40002: wordsize must be string or greater

1 Answers  


HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES

1 Answers  


DRG-10553: illegal syntax for column specification string

1 Answers  


Categories