Sahil,
The ORA-01451 error seems to be related to the column being modified to NULL cannot be modified to NULL. I found an article that shows each ORA error, and if you search the error there are some Causes and Actions you might be able to take to remedy the issue.
https://docs.oracle.com/cd/A58617_01/server.804/a58312/newch223.htm. I have also wrote it below:
"Cause: The column may already allow NULL values, the NOT NULL constraint is part of a primary key or check constraint, or an ALTER TABLE MODIFY statement attempted to change a column specification unnecessarily, from NULL to NULL.
Action: If a primary key or check constraint is enforcing the NOT NULL constraint, then drop that constraint."
Without knowing the attribute and how it was created makes knowing the specific issue harder.
------------------------------
Allan Henle
Projetech Inc.
------------------------------
Original Message:
Sent: 09-24-2021 10:28
From: Sahil Dutta
Subject: Regarding field required at db level
Hi All,How to make field not required.
We have made field required from database configuration application
When I am trying to make it not required and trying to do db config I get ORA-01451.
Please advise.
#Administration
------------------------------
Sahil Dutta
xyz
------------------------------