\nselect * from system.sales_transactions_ext;
\n
![\"file\"](\"\/wp-content\/uploads\/2020\/12\/image-1608018805496.png\")
<\/p>\n\u5177\u4f53\u9700\u6c42\uff1a\u5c06\u4e00\u4e2atxt\u6587\u4ef6\uff0c\u5bfc\u5165\u5230oracle\u6570\u636e\u5e93
\n\u89e3\u51b3\u601d\u8def\uff1a\u4f7f\u7528Oracle External\u00a0Tables
\n\u64cd\u4f5c\u6b65\u9aa4\uff1a
\n1\uff09\u786e\u8ba4txt\u7684\u6570\u636e\uff0c\u660e\u786e\u6570\u636e\u5b57\u6bb5\u7c7b\u578b
\n[oracle@hammer ~]$ cat sh_sales.dat
\n20201215001|02|2020\/12\/15|aa|98|36|1000|3000|9999
\n\u53ef\u4ee5\u770b\u51fa\uff0c\u5404\u4e2a\u5b57\u6bb5\u7528\u201c|\u201d\u9694\u79bb\uff0c\u7b2c\u4e09\u5217\u4e3a\u65e5\u671f\u578b\u6570\u636e\uff0c\u7b2c\u56db\u5217\u4e3a\u5b57\u7b26\u578b\uff0c\u5176\u4ed6\u5747\u4e3a\u6570\u5b57\u578b\uff0c\u5176\u4e2d\u540e\u4e09\u5217\u9700\u8981\u4fdd\u75592\u4f4d\u5c0f\u6570\u70b9
\n2\uff09\u786e\u8ba4txt\u7684\u8def\u5f84
\n[oracle@hammer ~]$ pwd
\n\/home\/oracle
\n3\uff09\u521b\u5efaDIRECTORY
\nCREATE OR REPLACE DIRECTORY data_file_dir AS '\/home\/oracle';
\nGRANT WRITE ON DIRECTORY data_file_dir TO public;
\n4\uff09\u521b\u5efa\u5916\u90e8\u8868sales_transactions_ext
\nconn system\/xxxxxx
\nCREATE TABLE sales_transactions_ext
\n(PROD_ID NUMBER,
\nCUST_ID NUMBER,
\nTIME_ID DATE,
\nCHANNEL_ID varchar2(20),
\nPROMO_ID NUMBER,
\nQUANTITY_SOLD NUMBER,
\nAMOUNT_SOLD NUMBER(10,2),
\nUNIT_COST NUMBER(10,2),
\nUNIT_PRICE NUMBER(10,2))
\nORGANIZATION external
\n(TYPE oracle_loader
\nDEFAULT DIRECTORY data_file_dir
\nACCESS PARAMETERS
\n(RECORDS DELIMITED BY NEWLINE
\nCHARACTERSET US7ASCII
\nBADFILE data_file_dir:'sh_sales.bad_xt'
\nLOGFILE data_file_dir:'sh_sales.log_xt'
\nFIELDS TERMINATED BY "|" LDRTRIM
\n( PROD_ID,
\nCUST_ID,
\nTIME_ID DATE(10) "YYYY\/MM\/DD",
\nCHANNEL_ID,
\nPROMO_ID,
\nQUANTITY_SOLD,
\nAMOUNT_SOLD,
\nUNIT_COST,
\nUNIT_PRICE))
\nlocation ('sh_sales.dat')
\n)REJECT LIMIT UNLIMITED;<\/p>\n
5\uff09\u9a8c\u8bc1
\nselect * from system.sales_transactions_ext;
\n<\/p>\n
\u6ce8\uff1a<\/p>\n
\u53ef\u53c2\u800311g\u5b98\u65b9\u6587\u6863
\nAdministrator's Guide-->20\u00a0Managing\u00a0Tables-->Managing\u00a0External\u00a0Tables<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5177\u4f53\u9700\u6c42\uff1a\u5c06\u4e00\u4e2atxt\u6587\u4ef6\uff0c\u5bfc\u5165\u5230oracle\u6570\u636e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,40],"tags":[],"class_list":["post-1087","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1087"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1102,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1087\/revisions\/1102"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}