external table 썸네일형 리스트형 [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 --.. 더보기 External Tables conn /as sysdba; create or replace directory ext as 'c:\external\' grant read on ext to hr; grant wrtie on ext to hr; conn hr/hr -- 예제 : oracle_datapump drop table ext_employees; create table ext_employees organization external ( type oracle_datapump default directory ext location('emp.ext') ) as select * from employees; CREATE TABLE ( ) ORGANIZATION EXTERNAL (TYPE oracle_datapump DEFAULT DIRECT.. 더보기 이전 1 다음