var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Ora 2296 (cannot enable Agresso.) null values found
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.
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
Remember that in Oracle an empty string (i.e. length zero) is considered NULL as well.
WHERE DIM_2 IS NULL
Thank you, I have managed to find 2 empty rows which I missed out.