TRUNCATE TABLE

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022March 21, 2023

LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »

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 »

Truncate vs Delete in Oracle

by Ed Chen
May 27, 2020December 10, 2022

Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… 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 »

2 Unawared Cases May Produce Large Amount of Archived Logs

by Ed Chen
June 29, 2014December 11, 2022

At times, you may notice that the destination of archived logs was growing so fast unreasonably, and it could be worse, it grew too fast… Read More »