Home » Open Source » MySQL » Scheduling for Moving Oracle 9i Table to Mysql
Scheduling for Moving Oracle 9i Table to Mysql [message #43495] Tue, 29 July 2003 10:54 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
HI,
I am using Oracle 9i server. I want to schedule a job twice a day. The job is to move a table data from oracle 9i to mysql Database. Please give in detail.
I am new to oracle DBA.
Hope to hear from you

regards
Re: Scheduling for Moving Oracle 9i Table to Mysql [message #43498 is a reply to message #43495] Tue, 29 July 2003 12:49 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You would use the DBMS_JOB package to schedule the job, and most likely the UTL_FILE package to write the data out in some text format (delimited, fixed, etc.).

Here is an example of how to use UTL_FILE to write out a .CSV file:

How to do the DBMS_JOB in Oracle 9i [message #43544 is a reply to message #43495] Sat, 02 August 2003 07:50 Go to previous messageGo to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Dear Sir,

I want to do the scheduling of moving a Oracle 9i table to a text file and move automaticaly to another computer. As you told, I can do that moving job using a Procedure right. But you did not specify how to do the DBMS_JOB. Please tell me how to do the DBMS_JOB and the syntax for it.

waiting for your reply.

regards

shanly
Re: How to do the DBMS_JOB in Oracle 9i [message #43551 is a reply to message #43544] Sun, 03 August 2003 00:00 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
A description of DBMS_JOB and the relevent syntax is available in detail in the documentation (available online at tahiti.oracle.com - free registration), but a simple example is:

declare
  v_job  number;
begin
  dbms_job.submit(v_job, 'myproc;', trunc(sysdate) + (12/24), 'trunc(sysdate + 1) + (12/24)');
  commit;
end;
/


This would execute myproc at noon each day.
Previous Topic: Job Schedule for moving Oracle 9i Table to Mysql
Next Topic: Oracle & MySql
Goto Forum:
  


Current Time: Thu Mar 28 09:18:54 CDT 2024