Oracle´´½¨Íⲿ¹ÜÀí±í

ÒÔsystem»òÆäËû¹ÜÀíÔ±µÇ¼ ´´½¨Oracle¹Ü¿ØĿ¼
CREATE DIRECTORY hc_name_data_dir AS 'c:\ora\external\hc_name\';
CREATE DIRECTORY hc_name_log_dir AS 'c:\ora\external\hc_name\'; È·ÈÏ
SELECT * from dba_directories WHERE directory_name like '%HC%'; ÊÚÓèĿ¼ÏàӦȨÏÞ¸øÐèÒª´´½¨Íⲿ±íµÄÓû§
GRANT WRITE ON DIRECTORY hc_name_log_dir TO scott;
GRANT READ ON DIRECTORY hc_name_data_dir TO scott; È·ÈÏ
SELECT * from dba_tab_privs WHERE table_name like '%_DIR' AND grantee = 'SCOTT'; ÒÔ¸ÃÓû§Éí·ÝµÇ¼,ÈçÀýÖеÄscott ´´½¨Íⲿ¹ÜÀí±í
CREATE TABLE name(id number(6), firstname VARCHAR2(100), surname VARCHAR(36)) ORGANIZATION EXTERNAL(TYPE oracle_loader DEFAULT DIRECTORY HC_NAME_DATA_DIR ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII BADFILE 'HC_NAME_LOG_DIR' : 'name.bad' LOGFILE 'HC_NAME_LOG_DIR' : 'name.log' FIELDS TERMINATED BY " " OPTIONALLY ENCLOSED BY '\t') LOCATION ('name.txt')) REJECT LIMIT UNLIMITED; È·ÈÏ
SELECT table_name, default_directory_owner, default_directory_name from user_external_tables;

    ×¢ÒâÍⲿ¹ÜÀí±íÖ»¿É¶Á,ÇÒ²»¹éÊôÓÚÈκαí¿Õ¼ä.