Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extracting oracle database date ,time from withing shell script

352315May 16 2008 — edited May 16 2008
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2008
Added on May 16 2008
3 comments
2,249 views