Extracting oracle database date ,time from withing shell script
352315May 16 2008 — edited May 16 2008I want to extract system date and time from oracle db running on RHEL 4 from within a shell script. and append the extracted date and time to my export
file name i create while exporting data.
The generated file name will be of the following format
exp_<project_code>datetime.dmp
The project code is hard coded.
The date and time will be fetched in background from the database time