Originally posted by jmodic
It's quite simple, nothing misterious here. You have created this constraint as deferrable - look at the vaue of column DEFERRED in your DBA_CONSTRAINT query!
Jurij,

I am not sure if you have seen the DEFFERED column i posted, but let me post it again.

Code:
WW04_PRO> ed
Wrote file afiedt.buf

  1  Select
  2    CONSTRAINT_NAME, Constraint_Type, DEFERRABLE, DEFERRED
  3  from
  4    dba_constraints
  5  where
  6*   table_name = 'RLSCSHEV'
WW04_PRO> /

CONSTRAINT_NAME           CONSTRAINT_TYPE DEFERRABLE     DEFERRED
------------------------- --------------- -------------- ---------
PK_RLSCSHEV               P               NOT DEFERRABLE IMMEDIATE
Abhay.