Call to dbms_redefinition.copy_table_dependents ends with ORA-06550, PLS-00306: wrong number or type
Hallo,
as a developer I test the ROWDEPENDENCY feature of Oracle 10g R2 and try to "alter" an existing table to enable this feature on it.
So as described, I can use the dbms_redefinition Package. But it won't work.
I'm not a beginner, I work with Oracle and PL/SQL since Oracle 8i. DETAILTAB and REDEF_DETAILTAB have the same columns, just a number and a varchar2 column. Very simple testcase. TESTUSER has DBA role.
Example:
1 DECLARE error_count binary_integer;
2 BEGIN
3 dbms_redefinition.copy_table_dependents('TESTUSER', 'DETAILTAB', 'REDEF_DETAILTAB',
4 copy_indexes => dbms_redefinition.cons_orig_params,
5 copy_triggers => true,
as a developer I test the ROWDEPENDENCY feature of Oracle 10g R2 and try to "alter" an existing table to enable this feature on it.
So as described, I can use the dbms_redefinition Package. But it won't work.
I'm not a beginner, I work with Oracle and PL/SQL since Oracle 8i. DETAILTAB and REDEF_DETAILTAB have the same columns, just a number and a varchar2 column. Very simple testcase. TESTUSER has DBA role.
Example:
1 DECLARE error_count binary_integer;
2 BEGIN
3 dbms_redefinition.copy_table_dependents('TESTUSER', 'DETAILTAB', 'REDEF_DETAILTAB',
4 copy_indexes => dbms_redefinition.cons_orig_params,
5 copy_triggers => true,
0