not null [message #313359] |
Fri, 11 April 2008 08:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
caprikar
Messages: 226 Registered: March 2007
|
Senior Member |
|
|
Hi,
I have a table
SQL> desc cat_cal
Name Null? Type
----------------------------------------- -------- ----------------------------
P_ID NUMBER(6)
PDCT_ID NUMBER(15)
A_DATE DATE
CATG_ID NUMBER(4)
STATUS_CD VARCHAR2(2)
LOST_M NUMBER(7)
CT_USER_ID VARCHAR2(30)
This table suppose to have 3 not null columns but it did showup when i describe the table but when i try to alter the table
ALTER TABLE CAT_CAL
MODIFY(P_ID NOT NULL);
i'm getting --> ORA-01442: column to be modified to NOT NULL is already NOT NULL
Can anyone tell me why is that?
|
|
|
Re: not null [message #313361 is a reply to message #313359] |
Fri, 11 April 2008 08:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
Look at the USER_CONSTRAINTS table. See if you can find the NOT NULL constraint there.
Just a guess, perhaps it was altered to NOVALIDATE...?
Either that, or you are performing DESCRIBE and ALTER against different tables.
Ross Leishman
|
|
|