<div>
<div class="content wysiwyg-content">
Getting this error when trying to use dbms_redefinition package. 
 
SQL&gt; execute dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging'); 
 
BEGIN dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging'); END; 
 
&nbsp; 
 
* 
 
ERROR at line 1: 
 
ORA-12008: error in materialized view refresh path 
 
ORA-01632: max # extents (4096) reached in index 
 
CSUH_CUSTOM.ACTIVITY_ACCUMULATOR_PK_NEW 
 
ORA-06512: at &quot;SYS.DBMS_REDEFINITION&quot;, line 8 
 
ORA-06512: at &quot;SYS.DBMS_REDEFINITION&quot;, line 146 
 
ORA-06512: at line 1 
 
&nbsp;What steps should i take now? 

</div>
</div>

Getting this error when trying to use dbms_redefinition package.

SQL> execute dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging');

BEGIN dbms_redefinition.start_redef_table('CSUH_custom', 'aa_temp3', 'aa_temp3_staging'); END;

 

*

ERROR at line 1:

ORA-12008: error in materialized view refresh path

ORA-01632: max # extents (4096) reached in index

CSUH_CUSTOM.ACTIVITY_ACCUMULATOR_PK_NEW

ORA-06512: at "SYS.DBMS_REDEFINITION", line 8

ORA-06512: at "SYS.DBMS_REDEFINITION", line 146

ORA-06512: at line 1

 What steps should i take now?


dbms_redefinition error

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.