I am new to Oracle DB and am in need of some help. I would like to drop a specific column but i am getting a specific error. The issue specifically is:
SQL Error: ORA-12991: column is reference in a multi-column constraint Cause: an attempt was made to drop a column referenced by some constraints Action: Drop all constraints referencing the dropped column or specify CASCADE CONSTRAINTS in statement.
So i have gone ahead and searched for all the constraints that referenced the column by doing something like:
SELECT * FROM USER_TAB_COLS WHERE COLUMN_NAME = 'My_Column_Name'
After finding and removing all the referenced constraints on the column that i want to drop I tried to drop the column again but i am still getting the same issue. Before posting the question i did take some time to research before this and have read the potential of this being a "Supplemental Logging" issue. Again i am very new to oracle DB programming as such could someone please shed some light on this and maybe suggest how and why i can not drop the column after having temporarily removed the constraints that reference the column i want to drop? Thanks in advance!
PS: Using Cascade Constraint Personally i don't think will fix the issue and i also do not want to remove all constraints without knowing which of them are being removed. So this is not a viable solution for me.