Ok thas fine, I think i should have posted Defferable column as well..

But now i know that this table was built with NON DEFFERABLE & it still says so, how can we reason the issue now.

Well, let me give you this info..

1) Our Primary DB crashed on 02-May-04.
2) Till 02-May we had the NULLABLE as "N" in our primary db.
3) Since our primary had some hardware issues, we brought up the Standby.
4) In standby we are seeing this strange thing.
5) Intersetingly this issue is seen only on 4 tables which were created with NOLOGGING option.

But i believe all DDL will be logged since DDL is a updation of SYS base tables and so & all such sys objects will be logging mode..
So why is this definition of "NULLABLE" differing from primary?

Abhay.