Try the following example: TMD=`date '+%Y/%m/%d'` TMS=`date '+%Y%m%d%H%M%S'` sqlplus -s internal <<whisky set verif off pages 0 echo off feed off term off lines 200 spool $SHELLSRCDIR/dbcontents.$TMS.log select 'alter database rename file '''||name||''' to '''||name||''';' from v\$datafile; column member format a50 select 'alter database rename file '''||member||''' to '''||member||''';' from v\$logfile; spool off whisky
Regards Peter Lomax (Oracle DBA) Expertise Oracle SG/DSI/SIMBAD/AT&P OrangeFrance Bureau: *: - [EMAIL PROTECTED] (: (+33) (0)1 55 22 59 13 fax: (+33) (0)1 55 22 39 69 -----Message d'origine----- De: ASCI [mailto:[EMAIL PROTECTED]] Date: mardi 4 d�cembre 2001 17:21 �: Multiple recipients of list ORACLE-L Objet: Export question - appending date to dmp file Hello All, I am trying to append date to dmp file while exporting it , no luck any ideas.. exp userid=user/passwd imp file=EXPDATA$DATE.dmp (I need to have system date and if possible time (TIMESTAMP ) appended to it .) TIA Cheers RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
