Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running dbms_redef on a very large, LOB object table, getting snapshot too old: rollback segment num

User_XEAE4Oct 10 2017 — edited Oct 13 2017

Folks,

We are running , Oracle db 12.1.0.2 db.

I have this very large size LOB object table, it has 2 lob columns, total size is about 500GB .

My goal is to move this table, from TABLESPACE A to B.

I am trying to use the DBMS_REDEFINITION package.

The procedure :

DBMS_REDEFINITION.START_REDEF_TABLE, ran for about 40 hrs and then gave this error

ORA-12008: error in materialized view refresh path

ORA-01555: snapshot too old: rollback segment number with name "" too small

ORA-22924: snapshot too old

ORA-06512: at "SYS.DBMS_REDEFINITION"

-------------------

Any help or suggestion , will be much appreciated.

Thanks,

Ashish

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2017

Added on Oct 10 2017

#general-database-discussions

17 comments

4,089 views