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

NNL-00803: Queries received, type ALIAS: number

1 Answers  


TNS-01059: Environment : string

1 Answers  


ORA-25456: rule set was modified or evaluation terminated for iterator: string

1 Answers  


SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files

1 Answers  


QSM-01021: materialized view, string, not found in the hint list

1 Answers  






PLS-01903: : non-integer error number

1 Answers  


ORA-06117: NETTCP: unable to create ORASRV: quota exceeded

1 Answers  


ORA-25952: join index must only contain inner equi-joins

1 Answers  


DRG-50901: text query parser syntax error on line string, column string

1 Answers  


ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


ORA-12078: fast refresh of refresh group ID string failed

1 Answers  


Categories