Database Utilities (MOSC)

MOSC Banner

ORA-1555 and LOB columns on 11203 single-instance under Linux 64bit

edited Jan 24, 2014 11:10AM in Database Utilities (MOSC) 11 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center