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).
