ORA-02266

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

by Ed Chen
June 9, 2021June 6, 2023
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, 2016May 25, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.