Re: ORACLE snapshot problem, help needed

In article <33BBB37E.1D57_at_epamail.epa.gov>, Dave Greene <greene.david_at_epamail.epa.gov> writes:

|> I am trying to create a snapshot group. The following is just one
|> version of many I have tried.
|>
|> EXECUTE DBMS_REFRESH.MAKE-
|> ('ATSP_GROUP','TALLOW_SS, TACCOUNT_SS',-
|> SYSDATE,(TRUNC(SYSDATE + 1) + 09/24))
|>

<snip out error codes>

|> Any thoughts, suggestions, solutions, or help would be appreciated.
|>
|> Dave Greene.

Dave, The problem appears to be the interval parameter. It should be a varch ar2 not a
date parameter. Should be able to put single quotes around it ie:

 EXECUTE DBMS_REFRESH.MAKE-
 ('ATSP_GROUP','TALLOW_SS, TACCOUNT_SS',SYSDATE,'(TRUNC(SYSDATE + 1) + 09/24)') Hope that helps

-- 
Stephen R. Egesdahl - Tektronix, Inc. - stephege_at_pogo.wv.tek.com

The opinions expressed are my own and do not necessarily reflect
those of Tektronix, Inc.


-- 
Stephen R. Egesdahl - Tektronix, Inc. - stephege_at_pogo.wv.tek.com

The opinions expressed are my own and do not necessarily reflect
those of Tektronix, Inc.