Suppose you have developed scripts to redefine tables using the dbms_redefinition package and the user is granted privilege to execute the dbms_redefinition package but still the user gets insufficient privilege error when the script is executed. What is possible reason for the error?

The user needs following privileges in addition to execute the dbms_redefinition package to be able to use the scripts:
? Create any table
? Drop any table
? Select any table
? Alter any table
? Lock any table
The COPY_TABLE_DEPENDENTS procedure requires additional privileges, which are given as follows:
? Create any trigger
? Create any index