rem 
rem $Header: cat70101.sql 7010200.1 93/11/15 00:13:18 snataraj Generic<base> $ 
rem 
Rem  Copyright (c) 1992 by Oracle Corporation 
Rem    NAME
Rem      cat70101.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      Upgrade script from 7.0 to 7.1
Rem    RETURNS
Rem 
Rem    NOTES
Rem      You must connect internal to run this script
Rem    MODIFIED   (MM/DD/YY)
Rem     dleary     11/04/93 -  move ora_tq_base$ to cat70102.sql
Rem     dleary     10/26/93 -  add ora_tq_base$ sequence
Rem     rjenkins   08/09/93 -  Creation
alter table snap$ add (
  refgroup        number,                    /* group for consistent refresh */
  ustrg           varchar2(30),           /* trigger for updatable snapshots */
  uslog           varchar2(30),               /* log for updatable snapshots */
  field1          number,                                  /* for future use */
  field2          varchar2(30),                            /* for future use */
  flag            number                      /* 0x01, can use master log    */
                                              /* 0x02, snapshot is updatable */
)
/
update snap$ set flag = 0 where flag is null
/
update snap$ set flag = 1 where can_use_log is not null
/
