ORA-02266

How to Resolve ORA-01439: column to be modified must be empty to change datatype

by Ed Chen
June 9, 2021October 24, 2021
2 Comments

ORA-01439 ORA-01439 means that the data type of a column you want to change is not empty, you have to make it empty first, then… Read More »

How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys

by Ed Chen
December 17, 2016April 12, 2021

ORA-02266 ORA-02266 means that you can't truncate the table because reference keys constraint still depend on the data of the table. Truncate a Single Table… Read More »

How to Disable All Referencing Constraints Before Importing Data

by Ed Chen
December 13, 2016December 11, 2022

Disable Constraints Before you can import with table_exists_action=truncate, you have to disable all referencing constraints. Otherwise, you may get the error: ORA-02266: unique/primary keys in… Read More »