ORA-22297: warning: Open LOBs exist at transaction commit time



ORA-22297: warning: Open LOBs exist at transaction commit time..

Answer / guest

Cause: An attempt was made to commit a transaction with open
LOBs at transaction commit time.

Action: This is just a warning. The transaction was commited
successfully, but any domain or functional indexes on the
open LOBs were not updated. You may want to rebuild those
indexes.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01578: ORACLE data block corrupted (file # string, block # string)

1 Answers  


ORA-39090: Cannot add devices to file oriented job.

1 Answers  


QSM-01077: materialized view, string, is grouping at a higher level than query

1 Answers  


ORA-12413: labels do not belong to the same policy

1 Answers  


ORA-26077: direct path column array is not initialized

0 Answers  






ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.

1 Answers  


ORA-36312: (PHYS00) workspace object must be a dimension or dimensioned variable.

1 Answers  


ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 Answers  


ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

1 Answers  


ORA-29831: operator binding not found

1 Answers  


Categories