Re: ORACLE snapshot problem, help needed

From: nada <_at_pipe.nova.ca(nada)>
Date: 1997/07/08
Message-ID: <5pu2av$112q$1@smu007sv.pipe.nova.ca>#1/1

Try ...

execute dbms_refresh.make( -
/* name */ 'REFRESH_GROUP1', -
/* list */ ' -

 TABLE1, -
 TABLE2, -
 TABLE3, -

  ...
 TABLEn, -
  ', -
/* next_date */ sysdate, -
/* interval */ 'trunc(sysdate+1)+22/24', -
/* implicit_destroy */ TRUE, -
/* lax */ TRUE, -
/* job */ 0, -
/* rollback_segment */ NULL -

  )
;

It works for me...
Greg... Received on Tue Jul 08 1997 - 00:00:00 CDT