Re: Change Column from CHAR to VARCHAR2: ORA-02267

Don Seiler wrote:

> I want to change a CHAR(15) field in two tables to VARCHAR2(32). However
> whenever I do I get this error:
>
> ORA-02267: column type incompatible with referenced column type
>
> I must note that this field is the sole PK field in the first table, and
> part of the PK in the other table. It is also the FK from the second table
> to the first. I did disable the PK and FK constraints first but it made no
> difference.

Drop the foreign key first.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)