DB TO FILE 썸네일형 리스트형 [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 --.. 더보기 이전 1 다음