1 Reply Latest reply on Mar 28, 2012 8:01 AM by Johnreardon

    ora-12091 when trying to partition a table


      I am trying to do list partitioning on a table.While partitioning I came to know materalize view exist for that table.So i dropped the materalized view but still facing the same problem.

      I am getting the above error when I am trying to execute following command.

      exec DBMS_REDEFINITION.CAN_REDEF_TABLE('usrname','tblename');

      The database version is