ORA-1555 and LOB columns on 11203 single-instance under Linux 64bit
Hi all,
We've been receiving ORA-1555 many times since 2 weeks ago, more or less, every single time, with a table that has a LOB. Medium tables and small tables (meaning, none of them have 1 gb).
All databases use AUM and they are 11.2 (11203 and few 11202) all under Linux.
I've arrived at Note 467872.1, all the LOBs use Retention, and not PCTVERSION, so I understand they do their CR on the same tablespace they reside and not UNDO tablespace.
Since some of them had Retention different from UNDO_RETENTION parameter, I altered them to increase this value, but the errors continue, the ORA-1555 did not go away we increased the LOB's tablespace but the errors continue.