This content has been marked as final. Show 2 replies
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6002.htm#i2063793 gives you the syntax of the command.
I think the fact that you have two REFRESH clauses separated by a query rewrite clause is causing some confusion.
7 REFRESH COMPLETE
8 ON DEMAND
9 DISABLE QUERY REWRITE
10 REFRESH START WITH TRUNC( SYSDATE + 1 ) + 3/24 NEXT TRUNC( SYSDATE + 1 ) + 3/24
probably should be
START WITH TRUNC( SYSDATE + 1 ) + 3/24 NEXT TRUNC( SYSDATE + 1 ) + 3/24
DISABLE QUERY REWRITE
Thanks a lot Forbrich for your prompt reply and guidance.
I will try this one out and let you know the output.
Thanks once again.