FILE TO DB 썸네일형 리스트형 [ODI] File Server 정보(참조 URL) File 관련 URL- http://docs.oracle.com/cd/E14571_01/integrate.1111/e12644/files.htm#ODIKM454 Setting up the Topology- http://docs.oracle.com/cd/E14571_01/integrate.1111/e12644/files.htm#CJABICFD File encoding parameter 종류- http://docs.oracle.com/javase/1.4.2/docs/guide/intl/encoding.doc.html ODI11g: Creating an ODI Project and Interface: Exporting a Flat File to a Flat File- http://www.oracle.com/w.. 더보기 [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 다음