Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    74

    Unanswered: Ora 2296 (cannot enable Agresso.) null values found

    Hi

    I'm trying to modify a column from null to not null, I have populated the column so it has values in but when running

    ALTER TABLE "AGRESSO"."APOREQDETAIL" MODIFY("DIM_2" NOT NULL)

    I get the following error message

    Ora 02296 (cannot enable Agresso.) null values found. The dim_2 column does have values as I populated rows that had no data but for some reason it's not working. Can someone please help.

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    The error message is pretty clear: you do have NULL values in DIM_2

    Run the following statement to find the rows where DIM_2 is null
    Code:
    SELECT *
    FROM APOREQDETAIL
    WHERE DIM_2 IS NULL
    Remember that in Oracle an empty string (i.e. length zero) is considered NULL as well.

  3. #3
    Join Date
    Jan 2006
    Posts
    74
    Thank you, I have managed to find 2 empty rows which I missed out.
    Thanks Shammat

Posting Permissions

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