DB스토리

-- 데이터의 이전. External Table insert into~ Loader yes --Create Directory S SYS> create directory dmpdir as '/home/oracle'; Directory created. S SYS> grant write,read on directory dmpdir to scott,hr; Grant succeeded. S SCOTT> select * from all_directories; OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -----------------------------------------------..