| Scheduling for Moving Oracle 9i Table to Mysql [message #43495] |
Tue, 29 July 2003 10:54  |
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
|
|
|
|
|
|
| How to do the DBMS_JOB in Oracle 9i [message #43544 is a reply to message #43495] |
Sat, 02 August 2003 07:50  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
