------------Create directory
Create directory TMPDIR as ‘/home/oracle/ws5’;
-------------CREATE TABLE
CREATE TABLE prod_user.MASTER
(
"PRODUCT_ID" NUMBER(4),
"NAME" VARCHAR2(10),
"OBSOLETED" DATE
)
ORGANIZATION external
(
TYPE oracle_loader
DEFAULT DIRECTORY TMPDIR
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE skip 1
BADFILE 'TMPDIR':'master.bad'
LOGFILE 'TMPDIR':'master.txt_xt'
FIELDS TERMINATED BY ","
MISSING FIELD VALUES ARE NULL
(
product_id,
NAME CHAR(10),
obsoleted date(12) 'DD-mon-YYYY'
)
)
Location ( 'master.dat' )
)
parallel
REJECT LIMIT UNLIMITED;来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10804699/viewspace-626063/ ，如需转载，请注明出处，否则将追究法律责任。
