DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbms_refresh package

  1. #1
    Join Date
    Jun 2001
    Posts
    150

    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

  2. #2
    Join Date
    Jun 2001
    Posts
    150
    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
  •  


Click Here to Expand Forum to Full Width