Disable DDL commands in a TABLE

ALTER TABLE TABLE_NAME DISABLE TABLE LOCK;

This will prevent for example altering the table, or doing a truncate, but select/update/insert will continue working. To enable back DDL execute


ALTER TABLE TABLE_NAME ENABLE TABLE LOCK;