RE: Required Exporting Script

RE: Required Exporting Script

 

  

Either use a shell script to generate a parameter file each time you run exp
and specify parmfile as an exp command line argument
Or
Pass file & log and a constant parmfile name as exp command line arguments
in a shell script -- the other parameters can stay in the parmfile.

-----Original Message-----
From: Imtiaz
[mailto:oracledba-ezmlmshield-x63740990.[Email address protected]
Sent: Thursday, September 30, 2004 8: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