다른 명령
1) 테이블 초기화
TRUNCATE TABLE SCOTT.TB_ABC_CE; PURGE DBA_RECYCLEBIN; SELECT * FROM SCOTT.TB_ABC_CE;
2) 세션 병렬처리 설정
ALTER SESSION ENABLE PARALLEL DML; ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT=64;
3) 테이블 속성 변경 NOLOGGING , PARALLEL
ALTER TABLE SCOTT.TB_ABC_CE NOLOGGING PARALLEL 32;
INSERT INTO /*+ APPEND_VALUES */ SCOTT.TB_ABC_CE B SELECT /*+FULL(A) PARALLEL(A,32) */ * FROM SCOTT.TB_ABC A; COMMIT;
4) 속성 복구
ALTER TABLE SCOTT.TB_ABC_CE LOGGING NOPARALLEL;
5) 인덱스 생성
ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT=64; CREATE INDEX GSSMADM.IX_IN_ABC_CE_01 ON SCOTT.TB_ABC_CE (SITE_CD, STKTAKE_NO, STKTAKE_SBJ_YN) NOLOGGING TABLESPACE TS_MIG UNUSABLE PARALLEL 4; ALTER INDEX GSSMADM.IX_IN_ABC_CE_01 REBUILD NOLOGGING PARALLEL 4; ALTER INDEX GSSMADM.PK_IN_ABC_CE REBUILD NOLOGGING PARALLEL 8; ALTER INDEX GSSMADM.PK_IN_ABC_CE LOGGING NOPARALLEL;