-
dbms_refresh package
HI
I am compiling this procedure
declare
vSnapshotList dbms_utility.uncl_array;
begin
vSnapshotList(1):= 'V_NETPROV_IMAGE';
vSnapshotList(2):= 'V_PART_ACCESSORY';
vSnapshotList(3):= 'V_PART_ACCESSORY_MAN';
vSnapshotList(4):= 'V_PART_ARTICLE';
vSnapshotList(5):= 'V_PART_COLOUR';
vSnapshotList(6):= 'V_PART_COLOUR_OPEN';
vSnapshotList(7):= 'V_PART_FEATURES';
vSnapshotList(8):= 'V_PART_MAN';
vSnapshotList(9):= 'V_PART_PARTMODEL';
vSnapshotList(10):= 'V_PDA';
vSnapshotList(11):= 'V_ACCESS_CAT';
vSnapshotList(12):= 'V_PPLAN_LINES';
vSnapshotList(13):= 'V_PRODUCT_ARTICLE';
vSnapshotList(14):= 'V_PRODUCT_CATEGORY';
vSnapshotList(15):= 'V_PRODUCT_FEATURES';
vSnapshotList(16):= 'V_PRODUCT_MAN';
vSnapshotList(17):= 'V_PRODUCT_MINMAX';
vSnapshotList(18):= 'V_PRODUCT_NETWORK';
vSnapshotList(19):= 'V_PRODUCT_PRICE';
vSnapshotList(20):= 'V_RINGTONECAT_ARTICLE';
vSnapshotList(21):= 'V_SPECIAL_OFFER';
vSnapshotList(22):= 'V_SRVPROV_IMAGE';
vSnapshotList(23):= 'V_TARIFF_FEATURES';
vSnapshotList(24):= 'V_TARIFF_IMAGE';
vSnapshotList(25):= 'V_TARVAR_FEATURES';
vSnapshotList(26):= 'V_TARVAR_PROD';
DBMS_REFRESH.MAKE(name =>'BERUK_MV_GRP',
tab => vSnapshotList,
next_date => TRUNC(sysdate)+1,
interval => 'sysdate+1/24');
end;
/
and i get this error message
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REFRESH", line 39
ORA-06512: at "SYS.DBMS_REFRESH", line 105
ORA-06512: at line 5
Any idea why this is happening.
Thanks
UKDBA
-
I have fixed this problem by putting all snapshots in list rather than creating an array.And to run it i have to do
exec dbms_refresh.refresh('BERUK_MV_GRP');
but now i want to submit a job who will execute this dbms package every hour.so what i am doing is
exec dbms_job.isubmit(100,'exec dbms_refresh.refresh('BERUK_MV_GRP');',sysdate,sysdate+1/24);
but i receive this error
ERROR at line 1:
ORA-06550: line 1, column 63:
PLS-00103: Encountered the symbol "BERUK_MV_GRP" when expecting one of the
following:
. ( ) , * @ % & | = - + < / > at in mod not range rem => ..
<> or != or ~= >= <= <> and or like
between is null is not || is dangling
The symbol ". was inserted before "BERUK_MV_GRP" to continue.
ORA-06550: line 4, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
begin declare end exception exit for goto if loop mod null
pragma raise return select update while
Any idea?
UKDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|