Utility for load data from text file (flow-stat) to the Oracle database.
Text files getting by script:
----------
#!/bin/sh
dst=dst
src=src
year=`date -v-1d '+%Y'`
month=`date -v-1d '+%m'`
day=`date -v-1d '+%d'`
pref=/var/db/flows/MSR/STAT
/usr/local/bin/flow-cat /var/db/flows/MSR/$year/$year-$month/$year-$month-$day | /usr/local/bin/flow-nfilter -F pit-dst-ip | /usr/local/bin/flow-stat -f8 | grep -v "#" > $pref/$year-$month-$day$dst.txt
/usr/local/bin/flow-cat /var/db/flows/MSR/$year/$year-$month/$year-$month-$day | /usr/local/bin/flow-nfilter -F pit-src-ip | /usr/local/bin/flow-stat -f9 | grep -v "#" > $pref/$year-$month-$day$src.txt
----------
command line arguments example:
"jdbc:oracle:thin:user/[email protected]:1521:XE" "/stat"

loaded files will be moved to subfolder "/stat/loaded" (subfolder will be created automatically)
if data exist in database, it will be updated.

script for make table in database:
----------
  CREATE TABLE "FLOWSTAT"
   ("FLOWTYPE" VARCHAR2(3 CHAR),
	"FLOWDATE" VARCHAR2(10 CHAR),
	"IPADDR" VARCHAR2(15 CHAR),
	"FLOWS" VARCHAR2(30 CHAR),
	"OCTETS" VARCHAR2(30 CHAR),
	"PACKETS" VARCHAR2(30 CHAR)
   );
----------