| export scheduling problem [message #202767] |
Sun, 12 November 2006 02:54  |
khosravi
Messages: 68
Registered: April 2006
|
Member |
|
|
hello
please say to me what methods exists for scheduling export(expdp or exp)
and what is beter
i have tried to use dbms_scheduler package for scheduling export but i don't succeed
i even maked shell file (under linux) with below content
sh1.sh
******************************************************
* time > test.txt *
* exp ali/ali120@products file=/home/oracle/exp1.dmp *
* *
******************************************************
and i created EXECUTABLE job by dbms_scheduler that execute sh1.sh when the job run
the first line of sh1.sh (time > test.txt) execute fine but second line (exp ali/...)
dont execute
|
|
|
|
| Re: export scheduling problem [message #202769 is a reply to message #202767] |
Sun, 12 November 2006 04:31  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Before scheduling a script, first make sure that the script works fine..here the script itself is not working so that should be tackled first. To do that, try to execute the script manually and post what errors you are getting at the second line of the script.
|
|
|
|
|
|
|
|
|
|
| Re: export scheduling problem [message #202958 is a reply to message #202786] |
Mon, 13 November 2006 07:29 |
khosravi
Messages: 68
Registered: April 2006
|
Member |
|
|
error code is:
---------------------------------------------------
SQL> execute dbms_scheduler.run_job('EXP_JOB09');
BEGIN dbms_scheduler.run_job('EXP_JOB09'); END;
*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: 32512
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 1
-------------------------------------------------
if you think problem is environmental variables
please say that whitch environmental variables must be set
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
