Hi,
We have a table A with a primary key on COL1 char(6), COL2 varchar2(100)
The current values COL1 hold are '012345','12345','09876',........
We want to change COL1 data type to number
For this
We take a backup of table A
We disable the PK
We delete the data in table A
We change the data type of COL1
Problem:
Once we insert back into table A from the backup table we get
ERROR at line 1:
ORA-00001: unique constraint (USER.A.PK) violated
If the index is disabled, why this error is happening?
Appreciate your help.
Regards,