Re: calling dbms_redefinition via a stored procedure.

Hi,

I've still got a bit on an issue with the dbms_redefinition function,

If I have a table that I'm moving to unicode and all of the existing keys and constraints are
VARCHAR2 and they're moving to NVARCHAR I get an error

create table tableA (
  col1 Varchar2(3),
  col2 VARCHAR2 (31) primary key,
  col3 CLOB
);

create table tableA_temp (
  col1 Number(20),
  col2 NVARCHAR2 (31) primary key,
  colNew Number(5),
  col3 NCLOB
);

if I try to do to_nchar(col2) col2 I get an error in a dbms_redefinition.start...

If don't have a primary key I'd also get an error.

Any ideas?

Thanks

Rich Received on Mon Apr 10 2006 - 14:41:29 CDT