RDBMS REDEFINITION

Posted by Roshan on Aug 26, 2024; 12:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RDBMS-REDEFINITION-tp12644.html

Oracle 19c

Hello,

hopw you are fine.

is it possible to measure how much to increase UNDO? I am getting this error during RDBMS_REDEFINITION start.

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
BEGIN
*
ERROR at line 1:
ORA-12008: error in materialized view or zonemap refresh path
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'
ORA-06512: at "SYS.DBMS_REDEFINITION", line 113
ORA-06512: at "SYS.DBMS_REDEFINITION", line 4363
ORA-06512: at "SYS.DBMS_REDEFINITION", line 5757
ORA-06512: at line 2


Regards,
Roshan