Truncate vs Delete in Oracle
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 »Truncate vs Delete in Oracle
DELETE FROM
How Oracle Revert INSERT INTO
Rollback INSERT INTO If you have not committed INSERT INTO statements, then you have a chance to roll data back to the original state. Just… Read More »How Oracle Revert INSERT INTO
How to Resolve ORA-00903: invalid table name
ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name
2 Unawared Cases May Produce Large Amount of Archived Logs
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 »2 Unawared Cases May Produce Large Amount of Archived Logs