Adding/modifying columns

Hi

What's the easiest way to add/modify columns in a table, if new constraints should be added, too? The intuitive way doesn't work (using alter table add/modify). I tried to create a new table and to copy all rows of the original table into the new one. But then the question is, how to exchange both, so that all references from other tables automatically go to the new one?

What's the reason that constraint specifications aren't allowed for alter table add/modify? Basically Oracle should be able to check, whether the constraint is violated or not, and allow the operation if no violation is detected.

bye
--
Sam Jordan Received on Mon Jun 21 1999 - 07:59:02 CDT