How to automatically add datetime in exp backup file name?
Hi Experts,
I am taking export backup using parfile named 'expbackup.par' where code is written as
userid=system/xyz@testdb file=sblBackup.dmp log=test_exp.log buffer=10000000 full=y statistics=none
I want to eliminate fixed file and need file name like DDMMYYHR24sbl.dmp (as for example file name will be 2311082330sbl.dmp if backup taken on 23-NOV-08 at 11:30 pm). I need to do this using shell script, so that I can call it using corntab.
Can anyone help me with a sample sell script?
I am using Oracle 9.2.0.8 under AIX
Thanks in advance
Hossain
userid=system/xyz@testdb file=sblBackup.dmp log=test_exp.log buffer=10000000 full=y statistics=none
I want to eliminate fixed file and need file name like DDMMYYHR24sbl.dmp (as for example file name will be 2311082330sbl.dmp if backup taken on 23-NOV-08 at 11:30 pm). I need to do this using shell script, so that I can call it using corntab.
Can anyone help me with a sample sell script?
I am using Oracle 9.2.0.8 under AIX
Thanks in advance
Hossain
0