Package DBMS_REDEFINITION missing from Oracle 11g?
Privileges Required for the DBMS_REDEFINITION Package 11.2

You do not need that role, that is just an example. I would not use that role, as it grants execute privileges on a lot of other packages as well.

You need the following privileges:

grant execute on dbms_redefiniton to your_user;
grant create table to your_user;
grant create materialized view to your_user;
grant create trigger to your_user;


The above is enough, if you want to redefine tables in your own schema. If you want to redefine tables in other schemas, you will need the "ANY" privileges listed below:

CREATE ANY TABLE
ALTER ANY TABLE
DROP ANY TABLE
LOCK ANY TABLE
SELECT ANY TABLE
CREATE ANY TRIGGER
CREATE ANY INDEX