ORACLE snapshot problem, help needed

From: Dave Greene <greene.david_at_epamail.epa.gov>
Date: 1997/07/03
Message-ID: <33BBB37E.1D57@epamail.epa.gov>#1/1

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)) The following is the error I receive executing SQLPLUS in ORACLE MVS.

@sqlplus(group) (this is the sqlplus process command)

begin DBMS_REFRESH.MAKE ('ATSP_GROUP','TALLOW_SS, TACCOUNT_SS', SYSDATE,(TRUNC
(SYSDATE + 1) + 09/24)); end;

*
ERROR at line 1:

  ORA-00904: invalid column name
  ORA-06512: at "SYS.DBMS_JOB", line 45
  ORA-06512: at "SYS.DBMS_JOB", line 115
  ORA-06512: at "SYS.DBMS_IREFRESH", line 94
  ORA-06512: at "SYS.DBMS_IREFRESH", line 147
  ORA-06512: at "SYS.DBMS_REFRESH", line 97
  ORA-06512: at "SYS.DBMS_REFRESH", line 75
  ORA-06512: at line 1

Any thoughts, suggestions, solutions, or help would be appreciated.

Dave Greene. Received on Thu Jul 03 1997 - 00:00:00 CDT