| export schedule problem [message #201767] |
Mon, 06 November 2006 11:55  |
khosravi
Messages: 68
Registered: April 2006
|
Member |
|
|
hello
please help me
i want schedule export and i have created a job with this specification
-------------------------------------------------
BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE ( schedule_name => 'EXPORT_SCHEDULE1',
start_date => SYSTIMESTAMP,
end_date => SYSTIMESTAMP + INTERVAL '30' day,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1', comments => 'Every 1 HOUR');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM ( program_name => 'EXPORT_PROGRAM1',
program_action => ' exp system/ali120 FILE=/home/oracle/alifiles/exp1.dmp TABLES=alit1',
program_type => 'EXECUTABLE',
comments => 'My comments here'
,enabled => TRUE);
END;
/
BEGIN DBMS_SCHEDULER.CREATE_JOB (
job_name => 'EXP_JOB1',
program_name => 'EXPORT_PROGRAM1',
schedule_name => 'EXPORT_SCHEDULE1',
enabled=>TRUE);
END;
/
----------------------------------------------------
my job executed but export file(/home/oracle/alifiles/exp1.dmp) dont created
it dont difference that i use exp or expdp
when i query from DBA_SCHEDULER_JOBS the STATE of EXP_JOB1 is RUNNING for
always
and when i use dbms_scheduler.run_job for running the job it don't return and
export file don't created
|
|
|
|
| Re: export schedule problem [message #201774 is a reply to message #201767] |
Mon, 06 November 2006 12:28  |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Modify the EXP command so that it will (hopefully) generate a log file. Then open it and read what it says. Something like this:
program_action => ' exp system/ali120 FILE=/home/oracle/alifiles/exp1.dmp TABLES=alit1 LOG=/home/oracle/alifiles/test.log'
Besides, I hope that path to the export file is correct.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
