Snapshot Refresh Groups

From: <rspeaker_at_my-deja.com>
Date: Fri, 03 Dec 1999 20:59:19 GMT
Message-ID: <829av5$nqv$1@nnrp1.deja.com>

Hi,

I have 3 snapshots that require refreshing at the same time, so I wanted to put them into a snapshot refresh group. But I'm having some problems with the syntax. First, I tried to follow the example in the Oracle 8 Complete Reference book;

    execute DBMS_REFRESH.MAKE
    (name => 'ledger_group',

     list => 'local_ledger, local_ledger_totals',
     next_date => SysDate,
     interval => SysDate+7)

Well, as soon as I type the first line and hit enter, I get:

   SQL> exec dbms_refresh.make
   begin dbms_refresh.make; end;

         *
   ERROR at line 1:

   ORA-06550: line 1, column 7:
   PLS-00306: wrong number or types of arguments in call to 'MAKE'
   ORA-06550: line 1 column 7:

   PL/SQL: Statement ignored

   SQL> OK, so then I put the entire command into a shell script, all on one line, like this:

execute DBMS_REFRESH.MAKE (name => 'ledger_group', list => local_ledger, local_ledger_totals', next_date => SysDate, interval => SysDate+7)

this time, it appears to have a problem with the interval setting, as I get the following messages:

   SQL>@/tmp/rgmake
   begin dbms_refresh.make (name => 'ledger_group', list =>    local_ledger, local_ledger_totals', next_date => SysDate,    interval => SysDate+7); end;

   *
   ERROR at line 1:

   ORA-23319: parameter value "10-DEC-99" is not appropriate
   ORA-06512: at "SYS.DBMS_JOB", line 50
   ORA-06512: at "SYS.DBMS_JOB", line 120
   ORA-06512: at "SYS.DBMS_IREFRESH", line 92
   ORA-06512: at "SYS.DBMS_IREFRESH", line 152
   ORA-06512: at "SYS.DBMS_REFRESH", line 104
   ORA-06512: at "SYS.DBMS_REFRESH", line 78
   ORA-06512: at line 1

   SQL> I have my JOB_QUEUE_PROCESSES set to 2 and JOB_QUEUE_INTERVAL set to 120 in the init.ora file. Can anybody shed any light on what is wrong with this?

Thanks,
Roy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 03 1999 - 14:59:19 CST