ORA-12854: Parallel query is not supported on temporary LOBs



ORA-12854: Parallel query is not supported on temporary LOBs..

Answer / guest

Cause: The parallel query statement produced a temporary LOB.

Action: Turn off parallelism for the query or underlying table

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31209: DBMS_LDAP: PL/SQL - LDAP count_entry error.

1 Answers  


ORA-38703: Type string in header is not a flashback database log file.

1 Answers  


ORA-32333: disable table scn update for Materialized view

1 Answers  


SQL*Loader-00100: Syntax error on command-line

1 Answers  


ORA-13194: failed to decode supercell

1 Answers  






ORA-00446: background process started when not expected

1 Answers  


ORA-01496: specified chain row table form incorrect

1 Answers  


SQL*Loader-00600: Bind size of number bytes increased to number bytes to hold 1 row.

1 Answers  


PLS-00316: PL/SQL TABLEs must use a single index

1 Answers  


ORA-32821: subscriber queue and exception queue must have same payload type

1 Answers  


ORA-38765: Flashed back database cannot be opened read-only.

1 Answers  


RMAN-06079: database must be mounted to perform recovery

1 Answers  


Categories