Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export question - appending date to dmp file
<FONT face=Arial color=#0000ff
size=2>file=expdata`date '+%y%m%d'`.dmp
<FONT face=Tahoma
size=2>-----Original Message-----From: ASCI
[mailto:apps_sol_at_hotmail.com]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
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
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.<A
href="mailto:dwilliams_at_lifetouch.com">dwilliams_at_lifetouch.com-----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: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author:
DENNIS WILLIAMS INET: <A
href="mailto:DWILLIAMS_at_LIFETOUCH.COM">DWILLIAMS_at_LIFETOUCH.COMFat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California
![]() |
![]() |