Search notes:

Oracle: DBMS_REDEFINITION

Necessary privileges

By default, the execute privilege on dbms_redefinition is granted to EXECUTE_CATALOG_ROLE. If this role is not granted, Oracle will throw the error message PLS-00201: identifier 'DBMS_REDEFINITION' must be declared:

grant execute on dbms_redefinition to …;

In order to use dbms_redefinition, the user must also have the rights to create materialized views. Otherwise, the error message ORA-01031: insufficient privileges is thrown.

grant  create materialized view to …;

Procedures

`abort_redef_table`
`abort_rollback`
`abort_update`
`can_redef_table`
`copy_table_dependents`
`execute_update`	Execute `update` statements in direct insert mode, i. e. with reduced redo generation to improve performance.
`finish_redef_table`
`redef_table`
`register_dependent_object`
`rollback`
`set_param`
`start_redef_table`
`sync_interim_table`
`unregister_dependent_object`

Oracle: DBMS_REDEFINITION

Necessary privileges

Procedures

See also