Adding Constraints
From: Bob Swerdlow <swerdlow_at_maine.rr.com>
Date: Mon, 11 Mar 2002 19:09:57 GMT
Message-ID: <9i7j8.6674$26.619241_at_typhoon.maine.rr.com>
Date: Mon, 11 Mar 2002 19:09:57 GMT
Message-ID: <9i7j8.6674$26.619241_at_typhoon.maine.rr.com>
I cannot figure out how to add a constraint to an existing table.
ALTER TABLE MyTable MODIFY(id INTEGER PRIMARY KEY);
but this results in:
ERROR at line 1:
ORA-02253: constraint specification not allowed here
In other cases I want to add a REFERENCES constraint, but they all produce an error similar to this.
-- Bob Swerdlow Chief Operating Officer Transpose, LLC rswerdlow_at_transpose.comReceived on Mon Mar 11 2002 - 20:09:57 CET