Re: Snapshot Refresh Groups

From: <rspeaker_at_my-deja.com>
Date: Mon, 06 Dec 1999 19:25:06 GMT
Message-ID: <82h2hq$qf0$1@nnrp1.deja.com>

I tried putting the commands on a single line, in a file, and it complained about the 'interval' setting. Any other suggestions?

In article <384A2F60.1872_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> rspeaker_at_my-deja.com wrote:
> >
> > 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.

>

> Put it into a file, or use the SQL PLus separator (-)

>

> eg

>


> SQL> exec my_proc(param1, -


>           param2, -


>           etc );


>

> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com

>

> "Some days you're the pigeon, and some days you're the statue."
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 13:25:06 CST