Dear Ed,

Thanks it is working.

Imtiaz.


----- Original Message -----
From: "Edwards Ed" <Ed.[Email address protected]
To: <[Email address protected]
Sent: Thursday, September 30, 2004 8:02 PM
Subject: RE: Required Exporting Script


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
normal
> **Anything below this line is the original email text
>
>
> Did this work for you?
>
>
> -----Original Message-----
> From: Edwards, Ed
> Sent: Thursday, September 30, 2004 11:53 AM
> To: 'Imtiaz '
> Subject: RE: Required Exporting Script
> Importance: High
>
>
> export ORACLE_SID=efis
> today=`date '+%y%m%d'`
> export NLS_LANG=AMERICAN_AMERICA.UTF8
> cd /local/usrhome/efis/exports
> exp system/[Email Address Removed] log=/local/usrhome/efis/exports/D${today}_EFIS.log full=y compress=y
> buffer=8000000 recordlength=65535 direct=y consistent = y
> gzip *.dmp &
> gzip *.log &
> exit
>
>
>
> -----Original Message-----
> From: Imtiaz
> [mailto:oracledba-ezmlmshield-x63740990.[Email address protected]
> Sent: Thursday, September 30, 2004 11:47 AM
> To: LazyDBA Discussion
> Subject: Required Exporting Script
>
>
> Dear All,
>
> If anybody has a complete database exporting script which changes the date
> itself everyday of the export files created.
>
> I have tried with date variable but its not taking in the export parameter
> file it is taking the file name as date itself not the date value.
>
>
> Parameter file
> =============
> full=y
>
file=(/depndata4/Backup/ansdb3009_01.dmp,/depndata4/Backup/ansdb3009_02.dmp,
> /depndata4/Backup/ansdb3009_03.dmp)
> filesize=2147483648
> log=/depndata4/Backup/ansdb3009.log
> buffer=3000000
> statistics=none
>
> I want the above date should change by itself everyday.
>
> Thanks in advance.
>
>
> Mohammed Imtiaz
> Systems Administrator,
>
> Al Ansari Exchange
> Tel: (+971) 2-6227888 (extn) 511
> Mobile: (+971) 50-7724165
> Fax: (+971) 2-6224794
> E-Mail: [Email address protected]
> URL: http://www.alansariuae.com
> --------------------------------------------------------------------------
--
> --
> Islam Teaches : "Do not sniff at food like animals."
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
>




Oracle LazyDBA home page