There's a catastrophic data integrity problem that I wrote about a few
years ago.
I haven't tested recently but the last addendum says it's reported fixed in
19.1, and there's a workaround to bypass it.
https://jonathanlewis.wordpress.com/2010/02/15/lock-horror/
Regards
Jonathan Lewis
On Sun, Jun 28, 2020 at 9:47 PM Ram Raman <veeeraman@xxxxxxxxx> wrote:
so I have been working in oracle for a long time and did not know that it
is possible to disable DDL in all tables, but keep it open for INS/UPD/DEL.
Came across this command:
ALTER TABLE TABLE_NAME DISABLE TABLE LOCK;
Has anyone used this command in their env? Does it come with any caution
note
Ram
--