Oracle µÄһЩµ¼ÈëºÍµ¼³ö·½·¨

֮ǰÏîÄ¿ÓÐÓõ½µÄһЩµ¼ÈëºÍµ¼³ö£¬Ê±ÖÁÒѾÃÕûÀíһϣ¬×ö¸ö¼ÇºÅ
µ¼ÈëÎļþ£º
1. ÔÚij·¾¶ÏÂд¿ØÖÆÎļþ e:\testRegionControl.ctl £º
 load data
 infile  e:\region.txt
 truncate into table region
 fields terminated by X'09'
 TRAILING NULLCOLS
 (
 PPCC_ID      :PPCC_ID),
 PPCC_PRINT_CODE    :PPCC_PRINT_CODE,
 PPCC_STATUS     :PPCC_STATUS,
 PPCC_STATUS     :PPCC_STATUS,
 filler1      FILLER,
 PPCC_MPDC_CREATE_DATE   to_date('" + PPCC_MPDC_CREATE_DATE + "','YYYY-MM-DD'),
 PPCC_MPDC_UPDATE_POINT_FLAG  constant '1',
 PPCC_MPDC_AMT      to_number(trim(:PPCC_MPDC_AMT))
 )
2. ÓÃSQLldrÃüÁîµ¼ÈëÊý¾Ý£º
sqlldr silent=header feedback discards partitions userid=shawn/shawn@DEMO control=e:\testRegionControl.ctl log=e:\testRegionControl.log bad=e:\testRegionControl.bad
ÓÃexpdp µ¼³ö£¬Ç°ÌáÊÇdirectoryÒѾ­ËüËùÖ¸ÏòµÄ·¾¶´æÔÚ£º
expdp shawn/shawn@DEMO  directory=TEST_DIRECTORY dumpfile=test.dmp logfile=test.log
ÓÃexp µ¼³ö
exp shawn/shawn@DEMO file=D:/test1.dmp tables=(region) 
exp shawn/shawn@DEMO file=D:/test2.dmp tables=(emp,dept)
ÓÃSpool µ¼³öÊý¾Ýµ½Îı¾£º
1. Ê×Ïȱ༭Îļþ test_sqlldr_exp.sql:
**********************************************
set trimspool on
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
spool e:\Others\sp_test.txt
select * from region;
spool off
/
**********************************************
»òÕß
**********************************************
set wrap off
set linesize 100
set feedback off
set pagesize 0
set verify off
set termout off
set  lines 1024 trimo on trimspo on
set  echo off
spool e:\Others\sp_test.txt
select * from dual  where dual.dummy = null
/
select * from re