create job get full export [message #316693] |
Sun, 27 April 2008 19:36 |
Rafeek
Messages: 159 Registered: April 2007 Location: egypt
|
Senior Member |
|
|
hi all
i use oracle database 10g .
how can create SCHEDULER JOB to get full export of my database.
Thanx
RAfeek
|
|
|
|
|
|
Re: create job get full export [message #316703 is a reply to message #316701] |
Sun, 27 April 2008 21:03 |
Rafeek
Messages: 159 Registered: April 2007 Location: egypt
|
Senior Member |
|
|
thanx
but how can i change the job action every time job run?
i use command (exp hr/hr FILE=d:\exp.dmp FULL=y)
how can change the name of dmp file to get sysdate?
thanx
Rafeek
|
|
|
|
Re: create job get full export [message #316705 is a reply to message #316704] |
Sun, 27 April 2008 21:20 |
Rafeek
Messages: 159 Registered: April 2007 Location: egypt
|
Senior Member |
|
|
i use this script to get full export and use bat file
run by EXECUTABLE JOB.
for /F "tokens=2,3,4 delims=/ " %%d in ('date /T') do (
set jour=%%d%%e%%f
)
set DB_USERNAME=SYSTEM
set DB_PASSWORD=SYSTEMADMIN
set TNS_ALIAS=test
set DUMPFILE=F:\temp\%JOUR%_FULL_EXPORT_%TNS_ALIAS%.dmp
echo userid=%DB_USERNAME%/%DB_PASSWORD%@%TNS_ALIAS% >F:\temp\EXP.PAR
echo file=%DUMPFILE% >>F:\temp\EXP.PAR
echo log=F:\temp\%JOUR%_FULL_EXPORT_%TNS_ALIAS%.LOG >> F:\temp\EXP.PAR
echo full=y >>F:\temp\EXP.PAR
E:\oracle\product\10.2.0\db_1\BIN\EXP PARFILE=F:\temp\EXP.PAR
but i want to get create job get full export without use any files
thanx
rafeek
|
|
|