develog

[Oracle] Trigger, enable, disable 본문

DB/Oracle

[Oracle] Trigger, enable, disable

냐옴 2016. 5. 13. 18:57

ALTER TABLE MY_TABLE DISABLE ALL TRIGGERS;

ALTER TABLE MY_TABLE ENABLE ALL TRIGGERS;


'DB > Oracle' 카테고리의 다른 글

[Oracle] NOLOGGING  (0) 2016.07.13
[Oracle] SYS_CONNECT_BY_PATH  (0) 2016.06.20
[Oracle] RECYCLEBIN, 휴지통 비우기  (0) 2016.02.04
[Oracle] function-based index 조회  (0) 2016.02.04
[Oracle] SYSTIMESTAMP time zone  (0) 2016.02.03
Comments