1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
le sqlloader est ici .....
apres ....set FILE =fichier_data
set ORACLE_SID=TON_ALIAS
set REP=c:\REPERTOIRE_SCRIPT
set REP_SCRIPT=%REP%\Sql
set REP_LOG=%REP%\logs
set FIC_LOG=%REP_LOG%\test_insert.log
set CONNECT_USER="scott/tiger@%ORACLE_SID%"
set SCRIPT=%REP_SCRIPT%\insert.sql
(ECHO BEGINNING INSERT & date /t & time /T )>> %FIC_LOG%
for /f "tokens=1,2,3 delims=/ " %%i in ('date /t') DO SET date1=%%i-%%j-%%k
set FILE=test_insert.log-%date1%
(ECHO END INSERT & date /t & time /T )>> %FIC_LOG%
echo insert into table_T values (sysdate,'%FILE%'); > %SCRIPT%
echo commit; >>%SCRIPT%
echo exit; >> %SCRIPT%
sqlplus -s %CONNECT_USER% @%SCRIPT% >> %FIC_LOG% 2>&1
(ECHO END INSERT & date /t & time /T )>> %FIC_LOG% |
Partager