?????????????????????????????????????????е???????б????е????????????????????????????????????????????????????????????
????????????????????????????????????У????????????б???
?????????ν?????????????????????????????????????????Oracle???????????
????Oracle???????????????????????????ORACLE_LOADER????????????????????????????????????ORACLE_DATAPUMP?????????????????????dump???????dump??????????Oracle???????????????????????????????????Oracle?????????????????????????д????
??????????????????????????????С???????
????[oracle@node2 ~]$ du -sm P_20150626010000_2002371.0003479598
????274    P_20150626010000_2002371.0003479598
????[oracle@node2 ~]$ wc -l P_20150626010000_2002371.0003479598
????2899265 P_20150626010000_2002371.0003479598
????????????????????????????274M????2899265???????
??????Σ????????????????
CREATE TABLE emp_load
(subsid number(18)??
servnumber VARCHAR2(20 CHAR)??
subsprodid NUMBER(18)??
prodid VARCHAR2(32 CHAR)??
startdate date??
enddate  date??
owner VARCHAR2(4 CHAR))
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY tmp
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY "|"
( subsid      DECIMAL EXTERNAL??
servnumber  CHAR(20)??
subsprodid  DECIMAL EXTERNAL??
prodid  CHAR(32)??
startdate date "yyyymmddhh24miss"??
enddate date "yyyymmddhh24miss"??
owner   CHAR(4)
)
)
LOCATION ('P_20150626010000_2002371.0003479598')
);
?????????tmp?????????????????scott???????е??????scott?????????·???ж?д????
????????????scott???????иy??????
?????????????????????????????
????SQL> select count(*) from emp_load;
????COUNT(*)
????------------------
????2899265
?????????wc-l????????????
??????????????????б???????????ζ???????????????????????С??????????????????ж??????????????????????д??????????ο???????????????????????????????У???EMP_LOAD_2000.bad??EMP_LOAD_2000.log??