|
file=expdata`date '+%y%m%d'`.dmp
Yes, I agree, but I have a valid reason for doing
this in this way.. any sugesstions..
Ramana
----- Original Message -----
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 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).
|
