Re: Is there a way to time export/import

if you are running a Unix platform you can write a shell script to do this:

#!/bin/ksh

echo "Started export process at: $(date)"

exp user/pass file=exp.dmp log=exp.log <blah blah blah>

echo "Ended export process at: $(date)"

if you are on NT, you can do it with a SQL script:

spool outFile.txt

select "Started at: "||to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;

host exp user/pass file=exp.dmp log=exp.log <blah blah blah>

select "Ended at: "||to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;

spool off;

HTH,
Roy

In article <38FDEAD0.7FF3812F_at_deja.com>,   ttrivedi <ttrivedi_at_deja.com> wrote:
> Is there a way to time exports and imports without being present there
> physically and looking at a dang watch.
>
> Tapan
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 19 2000 - 00:00:00 CDT