#!/usr/bin/sh
 PASS="oracle"
 USER="oracle"
 IPSERV="192.168.10.15"
 TMP_DIR="/home/oracle/111"
 LOCAL_DIR="/mnt/oradata/EXPORT/2011"
 ORA_USER="oracle"
 ORA_PASSW="oracle"
 FILENAME="";
 DAY=`date +%d`;
 #DAY= 24 ;
 MONTH=`date +%m`;
 YEAR=`date +%Y`;
 END_DATE="";
 START_DATE=""
 PATH_=`dirname $ 0 `;
 QWERY_FILE="createtable.sql"
 END_DATE="TO_DATE ('$DAY/$MONTH/$YEAR 00:00:00', 'dd/mm/yyyy hh24:mi:ss')";

 if `test $DAY -eq  1 ` 		
 then
 	 if `test $MONTH -eq  1 `
 	 then
 	    YEAR=`expr $YEAR -  1 `;
 	  	FILENAME="year$YEAR";
 	 else
 	 	MONTH=`expr $MONTH -  1 `;
 	    FILENAME="month$MONTH$YEAR_mias";
 	 fi
     
 else 
 	DAY=`expr $DAY -  1 `;
    FILENAME=`date +%b`$DAY;
 fi
 START_DATE="TO_DATE ('$DAY/$MONTH/$YEAR 00:00:00', 'dd/mm/yyyy hh24:mi:ss')"; 
 
 echo "create table $FILENAME as select  * from  data1 where timemoment between $START_DATE AND $END_DATE;" > $PATH_/$QWERY_FILE;
 echo "select count(*) from $FILENAME;" >> $PATH_/$QWERY_FILE;
 echo "disconnect;" >> $PATH_/$QWERY_FILE;
 echo "quit;" >> $PATH_/$QWERY_FILE;
 echo " " >> $LOCAL_DIR/$FILENAME.log;
 echo "************************************************" >> $LOCAL_DIR/$FILENAME.log;
 echo "************ CREATE TABLE $FILENAME ************" >> $LOCAL_DIR/$FILENAME.log;
 echo "************************************************" >> $LOCAL_DIR/$FILENAME.log;
 echo "$ORACLE_HOME/bin/sqlplus $ORA_PASSW/$ORA_USER@dev10 @$PATH_/$QWERY_FILE " >> $LOCAL_DIR/$FILENAME.log;
`$ORACLE_HOME/bin/sqlplus $ORA_PASSW/$ORA_USER@dev10 @$PATH_/$QWERY_FILE cat >> $LOCAL_DIR/$FILENAME.log`;
 
 echo " " >> $LOCAL_DIR/$FILENAME.log;
 echo "******************************************************************" >> $LOCAL_DIR/$FILENAME.log;
 echo "** EXPORT TABLE $FILENAME to $LOCAL_DIR/$FILENAME.dmp" >> $LOCAL_DIR/$FILENAME.log;
 echo "*****************************************************************" >> $LOCAL_DIR/$FILENAME.log;
`$PATH_/ssh_backup.expect $IPSERV $PASS $USER $TMP_DIR $LOCAL_DIR $FILENAME $ORA_USER $ORA_PASSW >> $LOCAL_DIR/$FILENAME.log`;
 
 echo " " >> $LOCAL_DIR/$FILENAME.log;
 echo "******************************************************************" >> $LOCAL_DIR/$FILENAME.log;
 echo "** scp $IPSERV/$TMP_DIR/$FILENAME.dmp to $LOCAL_DIR/$FILENAME.dmp" >> $LOCAL_DIR/$FILENAME.log;
 echo "******************************************************************" >> $LOCAL_DIR/$FILENAME.log;
 #`$PATH_/sftp.expect $IPSERV $PASS $USER $TMP_DIR $LOCAL_DIR $FILENAME $ORA_USER $ORA_PASSW >> $LOCAL_DIR/$FILENAME.log`;
   
 echo " " >> $LOCAL_DIR/$FILENAME.log;
 echo "******************************************************************" >> $LOCAL_DIR/$FILENAME.log;
 echo "** IMPORT $LOCAL_DIR/$FILENAME.dmp to TABLE $FILENAME" >> $LOCAL_DIR/$FILENAME.log;
 echo "******************************************************************" >> $LOCAL_DIR/$FILENAME.log; 
 echo "$ORACLE_HOME/bin/imp $ORA_USER/$ORA_PASSW file=$LOCAL_DIR/$FILENAME.dmp grants=y constraints=y" >> $LOCAL_DIR/$FILENAME.log;
 $FILENAME.log`;
[color=red] `$ORACLE_HOME/bin/imp $ORA_USER/$ORA_PASSW file=$LOCAL_DIR/$FILENAME.dmp grants=y constraints=y`;[/color] # тут проблема
  

su oracle; 
echo $LD_LIBRARY_PATH;