Parallel 썸네일형 리스트형 [ORACLE] EXTERNAL TABLE test CONN / AS SYSDBA; -- FM) CREATE DIRECTORY dirctory_name AS 'dircetory_path'; -- THE AUTHORITY TO SELECT EXTERNAL TABLE. GRANT READ ON DIRECTORY DATA_PUMP_DIR TO SH; -- FM) GRANT READ ON DIRECTORY dirctory_name TO schema; -- THE AUTHORITY TO CREATE EXTERNAL TABLE. GRANT WRITE ON DIRECTORY DATA_PUMP_DIR TO SH; -- FM) GRANT WRITE ON DIRECTORY dirctory_name TO schema; CONN SH/SH; /*** *** 1. FILE --.. 더보기 Parallel Hint ALTER SESSION ENABLE PARALLEL DML; INSERT /*+ PARALLEL(test1,8)*/ INTO test1 select /*+FULL PARALLEL(test2,8)*/ * from test2; 더보기 이전 1 다음