RE: Export question - appending date to dmp file
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||''';' fromv\$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/ATP 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).
RE: Export question - appending date to dmp file
RK - The system nicely timestamps the file automatically for you. Isn't that good enough? Another idea - on Unix, tar several files and it will keep the system timestamps on them. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L 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: DENNIS WILLIAMS 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).
RE: Export question - appending date to dmp file
Try this: DUMPFILE=EXPDATA_$(date '+%m%d%Y%H%M').dmp echo $DUMPFILE should return something like: EXPDATA_120420011626.dmp Which means export started on Dec. 4, 2001 at 4:26 PM. do 'man date' to customize it further for your specific needs HTH Ed __ _ == -o)/ / (_)__ __ __ | Ed Sherman Oracle Certified Professional | /\\ /__/ / _ \/ // /\ \/ / | ECC International Corporation | _\_v __/_/_//_/\_,_/ /_/\_\ | Tel: (407) 859-7410 x2708 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] | == * * * Supporter of the coalition for grumpiness where grumpiness is due * * * -Original Message- Sent: Tuesday, December 04, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Yes, I agree, but I have a valid reason for doing this in this way.. any sugesstions.. Ramana - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Tuesday, December 04, 2001 12:01 PM RK - The system nicely timestamps the file automatically for you. Isn't that good enough? Another idea - on Unix, tar several files and it will keep the system timestamps on them. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L 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 http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] mailto:[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] mailto:[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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward 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).
Re: Export question - appending date to dmp file
Yes, I agree, but I have a valid reason for doing this in this way.. any sugesstions.. Ramana - Original Message - From: DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 04, 2001 12:01 PM Subject: RE: Export question - appending date to dmp file RK - The system nicely timestamps the file automatically for you. Isn't thatgood enough? Another idea - on Unix, tar several files and it will keep thesystem timestamps on them.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Tuesday, December 04, 2001 10:21 AMTo: Multiple recipients of list ORACLE-LHello All,I am trying to append date to dmp file while exporting it , no luck anyideas..exp userid=user/passwd imp file=EXPDATA$DATE.dmp(I need to have system date and if possible time (TIMESTAMP ) appended to it.)TIACheersRK--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Export question - appending date to dmp file
Try exp ... file=expdat.`date +%j`.dmp ... or whatever format is desired. Note that those are NOT quote marks, but grave marks. They mean the result of whatever command is inside them. You might want to do something like this in a script: JDATE=`date +%j' exp ... file=expdat.${JDATE}.dmp ... Of course, Julian date (%j) is not what you asked for. See: $ man date The possibities are endless. -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 11:01 AM RK - The system nicely timestamps the file automatically for you. Isn't that good enough? Another idea - on Unix, tar several files and it will keep the system timestamps on them. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L 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: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
RE: Export question - appending date to dmp file
file=expdata`date '+%y%m%d'`.dmp -Original Message-From: ASCI [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 04, 2001 2:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Export question - appending date to dmp file Yes, I agree, but I have a valid reason for doing this in this way.. any sugesstions.. Ramana - Original Message - From: DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 04, 2001 12:01 PM Subject: RE: Export question - appending date to dmp file RK - The system nicely timestamps the file automatically for you. Isn't thatgood enough? Another idea - on Unix, tar several files and it will keep thesystem timestamps on them.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Tuesday, December 04, 2001 10:21 AMTo: Multiple recipients of list ORACLE-LHello All,I am trying to append date to dmp file while exporting it , no luck anyideas..exp userid=user/passwd imp file=EXPDATA$DATE.dmp(I need to have system date and if possible time (TIMESTAMP ) appended to it.)TIACheersRK--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).