TRUNCATE TABLE

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022November 12, 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, 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 »

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, 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 »

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 »

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