My Oracle Support Banner

ORA-12091 Attempting Online Reorganization of Table with Materialized Views (Doc ID 177408.1)

Last updated on APRIL 12, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.

Symptoms

You attempt to re-organize a table ONLINE. The table contains materialized views.
You use the DBMS_REDEFINITION.START_REDEF_TABLE procedure to do this, and you receive an ORA-12091 "cannot online redefine table %s . %s with materialized views" error.

For example:

SQL> execute DBMS_REDEFINITION.START_REDEF_TABLE('TEST', -
> 'EMPX', -
> 'INT_EMPX', -
> 'empno empno, name last_name, deptno deptno');
BEGIN DBMS_REDEFINITION.START_REDEF_TABLE('TEST', ;

*
ERROR at line 1:
ORA-12091: cannot online redefine table "TEST"."EMPX" with materialized views
ORA-06512: at "SYS.DBMS_REDEFINITION", line 8
ORA-06512: at "SYS.DBMS_REDEFINITION", line 146
ORA-06512: at line 1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.