|
|
Re: refresh mv using oracle jobs everyday except for sunday @ 6 AM [message #444056 is a reply to message #443677] |
Thu, 18 February 2010 09:41 |
nishach33
Messages: 3 Registered: February 2010 Location: germantown
|
Junior Member |
|
|
declare
my_job number;
begin
dbms_job.submit(job => my_job,
what => 'exec dbms_mview.refresh(<'owner'>.<'object_name'>,'c');',
next_date => to_date('02/1/2010 02:00','MM/DD/YYYY HH24:MI'),
interval => 'trunc(decode(to_char(sysdate+1,''DY''),''SUN'',next_day(sysdate,''MON''),sysdate+1))+2/24');
commit;
end;
/
Can somebody please tell me what is wrong here?
|
|
|
|
Re: refresh mv using oracle jobs everyday except for sunday @ 6 AM [message #444062 is a reply to message #443655] |
Thu, 18 February 2010 10:38 |
nishach33
Messages: 3 Registered: February 2010 Location: germantown
|
Junior Member |
|
|
Sorry about that. I am getting the below error while trying to run the below syntax. I am pretty new to oracle so I am not able to figure it out.
declare
my_job number;
begin
dbms_job.submit(job => my_job,
what => 'exec dbms_mview.refresh(<'owner'>.<'object_name'>,'c');',
next_date => to_date('02/1/2010 02:00','MM/DD/YYYY HH24:MI'),
interval => 'trunc(decode(to_char(sysdate+1,''DY''),''SUN'',next_day(sysdate,''MON''),sysdate+1))
+2/24');
commit;
end;
/
ERROR at line 5:
ORA-06550: line 5, column 41:
PLS-00103: Encountered the symbol "<
OWNER>" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
[Updated on: Thu, 18 February 2010 10:40] Report message to a moderator
|
|
|
|