nohup sqlplus prod1/prod1 @index.sql > index.out 2>&1 &
nohup /export/home/oracle/restore.sh > /export/home/oracle/restore_`date '+%Y%m%d_%H%M%S'`.log 2>&1 &
nohup /export/home/oracle/restore.sh > /export/home/oracle/restore_`date '+%Y%m%d_%H%M%S'`.log 2>&1 &
3 comments:
nohup sqlplus '/ as sysdba' @/export/home/oracle/test.sql > /export/home/oracle/test.log 2>&1 &
spool date.sp
set time on timing on
alter session set nls_date_format='dd-mm-yyyy hh24:mi';
select sysdate from dual;
select count(*) from dba_objects; ----<<< your sql statement
select sysdate from dual;
spool off
exit
nohup sqlplus '/ as sysdba' @date.sql > date.txt 2>&1
Post a Comment