1 Reply Latest reply: Mar 28, 2012 3:01 AM by Johnreardon RSS

    ora-12091 when trying to partition a table

    860488
      Hi,

      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 10.1.0.5.