Encounter snapshot too old when trying to MOVE LOB to another tablespace
ChangCFFeb 1 2008 — edited Feb 6 2008Hi,
I have running a Oracle 10g R2 (10.2.0.3). I have a LOG segment that is I need to to move it to another tablespace (tbs rebuild) . I use the command :
alter table MY_TABLE move lob (my_table_coln) store as (tablespace NEW_TBS);
It fails with the error
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old...
What can i do to make this work. I have tried changing the PCTVERSION from 0 to 30. Still hit the same error. I have read how the PCTVERSION can help on prevent this. What else can I explore to work on this...