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 shermanej_at_eccic.com <mailto:shermanej_at_eccic.com> |  

• * * 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:ORACLE-L_at_fatcity.com> 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.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----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: DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> 

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: ListGuru_at_fatcity.com <mailto:ListGuru_at_fatcity.com>  (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: shermanej_at_eccic.com

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: ListGuru_at_fatcity.com (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).