› Fóruns › Banco de dados Oracle › Coluna Not Null › Coluna Not Null
30 de julho de 2010 às 9:35 pm
#95336
burgaParticipante
Segue uma resposta:
It’s just the way DESC clause in sqlplus queries the cdef$ and ccol$ data
dictionary tables. It only shows validated not null constraints there,
probably for consistency with Oracle optimizer behaviour, which cannot take
a not validated constraint seriously when optimizing execution plans.You can still see your constraint from dba_constraints, you just see it’s
not validated from there.Tanel.