TRUNCATE

How to Resolve ORA-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Resolve ORA-39325: TABLE_EXISTS_ACTION cannot be applied to

by Ed Chen
June 20, 2022August 30, 2022

ORA-39325 I found a table was not imported during data loading by impdp. After doing some investigation, I saw error ORA-39325 in the log. ORA-39325:… 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 »