Database Administration (MOSC)

MOSC Banner

Call to dbms_redefinition.copy_table_dependents ends with ORA-06550, PLS-00306: wrong number or type

edited Jul 24, 2009 7:42AM in Database Administration (MOSC) 11 commentsAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center