Re: Disable DDL

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_at_gmail.com> 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
> --
>
>
>

--
http://www.freelists.org/webpage/oracle-l