목록sunjesoft/Goldilocks Conversion (1)
나그네소
Oracle Conversion
> 1. goldilocks schema oracle에 create 2. login.sql/home/oracle/shw/oracle_sqlldr/login.sqlset pagesize 10000;set linesize 1024;set heading off;set feedback off 3. table.conf 목록 작성(Goldilocks)T_T1T_T2T_T3... 4. ctl file 생성(goldilocks)/home/oracle/shw/oracle_sqlldr/make_control.sh[shell]TABLES=`cat table.conf` echo "# import shell" > import_all.sh for TABLE in $TABLESdo echo "TABLE $TABLE" > $TABL..
sunjesoft/Goldilocks Conversion
2019. 10. 22. 19:01