Home » SQL & PL/SQL » SQL & PL/SQL » create job get full export
create job get full export [message #316693] Sun, 27 April 2008 19:36 Go to next message
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 #316697 is a reply to message #316693] Sun, 27 April 2008 20:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#CIHEHDHA
Re: create job get full export [message #316701 is a reply to message #316697] Sun, 27 April 2008 20:38 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
i known SCHEDULER JOB and create many JOBS
but how can i use it to get SCHEDULER full export from my database
(get file <file name>.dmp).
Re: create job get full export [message #316702 is a reply to message #316693] Sun, 27 April 2008 20:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1023560
Re: create job get full export [message #316703 is a reply to message #316701] Sun, 27 April 2008 21:03 Go to previous messageGo to next message
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 #316704 is a reply to message #316703] Sun, 27 April 2008 21:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Why don't you create a scheduled job of EXECUTABLE type that calls a shell script with your exp(dp) commands in it?

The information is in the first link Ana posted.
Re: create job get full export [message #316705 is a reply to message #316704] Sun, 27 April 2008 21:20 Go to previous message
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
Previous Topic: BIN File
Next Topic: Trigger help
Goto Forum:
  


Current Time: Thu Dec 05 20:29:06 CST 2024