Re: Decrease column size

You can drop the foreign keys from other tables first and recreate it later.

River

Sam Jordan wrote:
>
> Hi
>
> When trying to change a field from varchar2(30) to varchar2(20)
> an error message popped up saying that the column has to be empty
> in order to be able to perform this operation.
>
> Is there any quick way to achieve the same result? Note, that some
> fields have 'not null' constraints.
>
> My first idea doesn't work, as I wanted to make a backup of the table,
> deleting all entries, recreate the table and restoring the values. It
> fails, because some fields are referenced by other tables and thus can't
> be deleted.
>
> bye
> --
> Sam Jordan
Received on Sat Jul 03 1999 - 03:56:53 CDT