I have a Question here..
I have created a table Tab_test with some constraints
check (Emp_Sal>10000) and UPI on Emp_Id.
and loaded data from the source which contains duplicates..
So the duplicate values are loaded to an error table and now I wanted to change/modify the constraints of base table.
Is it possible to alter ..?
Note: I deleted the base table data.
Thanks in advance..
Your table is empty, you can make a change.
You cannot alter a populated primary‑indexed table to have a different set of primary index columns.