dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Default value on a not null field

  1. #1
    Join Date
    Sep 2001
    Posts
    1

    Exclamation

    Hi,

    We are experiencing different behaviors in our 8.1.7 env after an import from an 8.0.6 env.

    For example on table temp we have:
    col1 char(1) default 'X' not null

    The following sql in one of the new 8.1.7 instance works, but on the other it gives an error:

    insert into temp values (null) ;

    On the 2nd instance it gives the following error:
    ERROR at line 1:
    ORA-01400: cannot insert NULL into ("DP"."TEMP"."COL1")

    Both of the instances were created from the same dump file.

    Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It could be the bug, I heard that it had been resolved. I would suggest that you contact oracle for the patch.

    Sorry, I don't know the bug number.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width