Oracle DBA, How To, Error, Cause and Action

ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged

ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged


Cause:


An attempt was made to use LOB from a temporary table whose data has been dropped either because table was transaction-specific and transaction has commited or aborted, table was truncated or session which created this LOB has ended.



Action:


This LOB locator is invalid and cannot be used.

No comments:

Post a Comment

Thanks for your comment.