Decrease column size

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 Fri Jul 02 1999 - 07:53:07 CDT