Home » RDBMS Server » Server Administration » not null
not null [message #313359] Fri, 11 April 2008 08:44 Go to next message
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
rleishman
Messages: 3724
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
Previous Topic: tablespace related
Next Topic: Add controlfile in ASM encounter error ORA-00214 ?
Goto Forum:
  


Current Time: Tue Dec 06 06:19:06 CST 2016

Total time taken to generate the page: 0.16319 seconds