|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| deleting file with timestamp | jcluvme | UNIX for Dummies Questions & Answers | 2 | 01-10-2008 05:59 PM |
| File timestamp | stevefox | UNIX for Dummies Questions & Answers | 4 | 12-24-2007 09:14 PM |
| changing timestamp of a file | krishan | SUN Solaris | 1 | 05-23-2005 07:50 AM |
| timestamp of file | krisdhar | UNIX for Dummies Questions & Answers | 4 | 10-28-2003 06:31 AM |
| HP-UX lp spooling places | doeboy | UNIX for Advanced & Expert Users | 2 | 04-10-2002 09:21 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
03-23-2004
|
|||
|
|||
|
Spooling a log file with timestamp
Hi
From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp. can someone help me to do that . Thanks UKADMIN 
|
| Forum Sponsor | ||
|
|
|
03-23-2004
|
||||
|
||||
|
Well, if I understand you correctly, this is easy. After your shell script logs into Oracle and runs your sql, then disconects, use a mv command to rename your file.
%T gives a time format inmilitary time like 21:01:54 SPOOL-NAME=blah-blah-blah NEW-FILE-NAME=$SPOOL-NAME_$(date +'%T').csv mv $SPOOL-NAME $NEW-FILE-NAME
|
|
03-23-2004
|
||||
|
||||
|
Use the date command to generate output file name, e.g...
NAME=`date +extract_%Y-%m-%d_%H:%M:%S.csv` echo output file is $NAME sqlplus args > $NAME See man date for formatting
|
||||
| Google The UNIX and Linux Forums |
Linear Mode
