Home » RDBMS Server » Server Utilities » export schedule problem
export schedule problem [message #201767] Mon, 06 November 2006 11:55 Go to next message
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 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: IMP-00009: abnormal end of export file
Next Topic: Loading data into multiple tables
Goto Forum:
  


Current Time: Sat Dec 10 18:43:31 CST 2016

Total time taken to generate the page: 0.04357 seconds