Oracle Modify statement - error.

I added a new column in my table.

ALTER TABLE neue_buch modify preis not null;

and I have got this error.

print(" Error starting at line 40 in command: ALTER TABLE neue_buch modify preis not null Error report: SQL Error: ORA-02296: cannot enable (S1885872.) - null values found 02296. 00000 - "cannot enable (%s.%s) - null values found" *Cause: an alter table enable constraint failed because the table contains values that do not satisfy the constraint. *Action: Obvious

");

What wrong with my MODIFY STATEMENT.?

many thanks in advance,

magidu

From stackoverflow $pageUsers[$entry.posts[0].author].name

• The error message is telling you that there are some rows in NEUE_BUCH where the PREIS column is NULL. You will need to modify those rows to have non-NULL values before you can create this NOT NULL constraint.

  From Justin Cave

• thanksyou verymuch.

  Paul Tomblin : Instead of saying "thanksyou", click the arrow to accept it as the correct answer.

  BobbyShaftoe : I think there should be something changed in the UI to make it more clear to accept people's answers. I rarely questions with accepted answers, even though there are clear answers to be accepted.
  From $pageUsers[$post.author].name

• ALTER TABLE AG_PARTICELLE_AZIENDA MODIFY SEZIONE NOT NULL; ORA-02296: impossibile abilitare (TRACKER.) - trovati valori non appropriati

  nella tabella AG_PARTICELLE_AZIENDA alcuni valori di SEZIONE sono a null!

  devo fare:

  1)update AG_PARTICELLE_AZIENDA set sezione = null;

  2)commit;

  3)ALTER TABLE AG_PARTICELLE_AZIENDA MODIFY SEZIONE NOT NULL;

  non ho capito il messaggio di errore! qualcquno può aiutarmi? grazie ugo montorsi mail:ugo.montorsi@sin.it

  From $pageUsers[$post.author].name