[SQLPํ์ค๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(1) ์ํธํ๋
- 8๋ฒ , 12
[SQLPํ์ค๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(2) DMLํ๋
- 31๋ฒ
[SQLPํ์ค๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(4) ํํฐ์
๋
- 24๋ฒ
๊ด๋ จ ๋งํฌ : https://velog.io/@yooha9621/SQLP์ค๊ธฐํ์ด-์ํธํ๋12๋ฒ-rj0zat6k
๊ด๋ จ ๋งํฌ : https://velog.io/@yooha9621/SQLP์ค๊ธฐํ์ด-๋๋DMLํ๋31๋ฒ
ALTER TABLE TARGET_T MODIFY CONSTRAINT TARGET_T_PK DISABLE DROP INDEX;
ALTER TABLE TARGET_T MODIFY CONSTRAINT TARGET_T_PK ENABLE NOVALIDATE;
ALTER TABLE TARGET_T NOLOGGING;
ALTER TABLE TARGET_T LOGGING;
ALTER SESSION ENABLE PARALLEL DML;
ALTER SESSION DISABLE PARALLEL DML;
TRUNCATE TABLE TARGET_T ;