-- This script is to generate backup copies (SAVE_*) of all CERA tables:
-- ---------- CERA 2.3 + Modules DATA_ACCESS 1.0 + DATA_ORGANIZATION 1.2
-- -------------------------------------------------------- FT, 99.01.29
--
spool saveCERA
--
  drop table SAVE_ACCESS_CONSTRAINT ;
create table SAVE_ACCESS_CONSTRAINT as (select * from ACCESS_CONSTRAINT );
  drop table SAVE_ACCESS_STRUCTURE  ;
create table SAVE_ACCESS_STRUCTURE  as (select * from ACCESS_STRUCTURE  );
  drop table SAVE_ACCESS_TYPE       ;
create table SAVE_ACCESS_TYPE       as (select * from ACCESS_TYPE       );
  drop table SAVE_AGGREGATION       ;
create table SAVE_AGGREGATION       as (select * from AGGREGATION       );
  drop table SAVE_CAMPAIGN          ;
create table SAVE_CAMPAIGN          as (select * from CAMPAIGN          );
  drop table SAVE_CITATION          ;
create table SAVE_CITATION          as (select * from CITATION          );
  drop table SAVE_CITATION_TYPE     ;
create table SAVE_CITATION_TYPE     as (select * from CITATION_TYPE     );
  drop table SAVE_CONNECT_TYPE      ;
create table SAVE_CONNECT_TYPE      as (select * from CONNECT_TYPE      );
  drop table SAVE_CONTACT           ;
create table SAVE_CONTACT           as (select * from CONTACT           );
  drop table SAVE_CONTACT_TYPE      ;
create table SAVE_CONTACT_TYPE      as (select * from CONTACT_TYPE      );
  drop table SAVE_COVERAGE          ;
create table SAVE_COVERAGE          as (select * from COVERAGE          );
  drop table SAVE_CURRENTNESS_REF   ;
create table SAVE_CURRENTNESS_REF   as (select * from CURRENTNESS_REF   );
  drop table SAVE_DATA_ACCESS       ;
create table SAVE_DATA_ACCESS       as (select * from DATA_ACCESS       );
  drop table SAVE_DATA_ORG          ;
create table SAVE_DATA_ORG          as (select * from DATA_ORG          );
  drop table SAVE_DIM_TYPE          ;
create table SAVE_DIM_TYPE          as (select * from DIM_TYPE          );
  drop table SAVE_DISTRIBUTION      ;
create table SAVE_DISTRIBUTION      as (select * from DISTRIBUTION      );
  drop table SAVE_ENTRY             ;
create table SAVE_ENTRY             as (select * from ENTRY             );
  drop table SAVE_ENTRY_CONNECT     ;
create table SAVE_ENTRY_CONNECT     as (select * from ENTRY_CONNECT     );
  drop table SAVE_ENTRY_TYPE        ;
create table SAVE_ENTRY_TYPE        as (select * from ENTRY_TYPE        );
  drop table SAVE_FEES              ;
create table SAVE_FEES              as (select * from FEES              );
  drop table SAVE_FORMAT            ;
create table SAVE_FORMAT            as (select * from FORMAT            );
  drop table SAVE_GENERAL_KEY       ;
create table SAVE_GENERAL_KEY       as (select * from GENERAL_KEY       );
  drop table SAVE_HOR_COORD_SYS     ;
create table SAVE_HOR_COORD_SYS     as (select * from HOR_COORD_SYS     );
  drop table SAVE_INSTITUTE         ;
create table SAVE_INSTITUTE         as (select * from INSTITUTE         );
  drop table SAVE_KEY_CONNECT       ;
create table SAVE_KEY_CONNECT       as (select * from KEY_CONNECT       );
  drop table SAVE_LOCATION          ;
create table SAVE_LOCATION          as (select * from LOCATION          );
  drop table SAVE_LOCATION_CONNECT  ;
create table SAVE_LOCATION_CONNECT  as (select * from LOCATION_CONNECT  );
  drop table SAVE_MODEL             ;
create table SAVE_MODEL             as (select * from MODEL             );
  drop table SAVE_MODEL_INPUT       ;
create table SAVE_MODEL_INPUT       as (select * from MODEL_INPUT       );
  drop table SAVE_MODEL_TYPE        ;
create table SAVE_MODEL_TYPE        as (select * from MODEL_TYPE        );
  drop table SAVE_MOMENT            ;
create table SAVE_MOMENT            as (select * from MOMENT            );
  drop table SAVE_PARAMETER         ;
create table SAVE_PARAMETER         as (select * from PARAMETER         );
  drop table SAVE_PERSON            ;
create table SAVE_PERSON            as (select * from PERSON            );
  drop table SAVE_POINT             ;
create table SAVE_POINT             as (select * from POINT             );
  drop table SAVE_POINT_CONNECT     ;
create table SAVE_POINT_CONNECT     as (select * from POINT_CONNECT     );
  drop table SAVE_POINT_SET         ;
create table SAVE_POINT_SET         as (select * from POINT_SET         );
  drop table SAVE_POSITION          ;
create table SAVE_POSITION          as (select * from POSITION          );
  drop table SAVE_PRESENTATION      ;
create table SAVE_PRESENTATION      as (select * from PRESENTATION      );
  drop table SAVE_PROCESS_STEP      ;
create table SAVE_PROCESS_STEP      as (select * from PROCESS_STEP      );
  drop table SAVE_PROGRESS          ;
create table SAVE_PROGRESS          as (select * from PROGRESS          );
  drop table SAVE_PROJECT           ;
create table SAVE_PROJECT           as (select * from PROJECT           );
  drop table SAVE_QUALITY           ;
create table SAVE_QUALITY           as (select * from QUALITY           );
  drop table SAVE_REC_STRUCTURE     ;
create table SAVE_REC_STRUCTURE     as (select * from REC_STRUCTURE     );
  drop table SAVE_REFERENCE         ;
create table SAVE_REFERENCE         as (select * from REFERENCE         );
  drop table SAVE_REF_TYPE          ;
create table SAVE_REF_TYPE          as (select * from REF_TYPE          );
  drop table SAVE_SCALE             ;
create table SAVE_SCALE             as (select * from SCALE             );
  drop table SAVE_SCALE_CONNECT     ;
create table SAVE_SCALE_CONNECT     as (select * from SCALE_CONNECT     );
  drop table SAVE_SPACE             ;
create table SAVE_SPACE             as (select * from SPACE             );
  drop table SAVE_SPATIAL_COVERAGE  ;
create table SAVE_SPATIAL_COVERAGE  as (select * from SPATIAL_COVERAGE  );
  drop table SAVE_SPATIAL_DATA_ORG  ;
create table SAVE_SPATIAL_DATA_ORG  as (select * from SPATIAL_DATA_ORG  );
  drop table SAVE_SPATIAL_REFERENCE ;
create table SAVE_SPATIAL_REFERENCE as (select * from SPATIAL_REFERENCE );
  drop table SAVE_STORAGE           ;
create table SAVE_STORAGE           as (select * from STORAGE           );
  drop table SAVE_SUMMARY           ;
create table SAVE_SUMMARY           as (select * from SUMMARY           );
  drop table SAVE_TEMPORAL_COVERAGE ;
create table SAVE_TEMPORAL_COVERAGE as (select * from TEMPORAL_COVERAGE );
  drop table SAVE_TIME              ;
create table SAVE_TIME              as (select * from TIME              );
  drop table SAVE_TIME_CONNECT      ;
create table SAVE_TIME_CONNECT      as (select * from TIME_CONNECT      );
  drop table SAVE_TOPIC             ;
create table SAVE_TOPIC             as (select * from TOPIC             );
  drop table SAVE_UNIT              ;
create table SAVE_UNIT              as (select * from UNIT              );
  drop table SAVE_USE_CONSTRAINT    ;
create table SAVE_USE_CONSTRAINT    as (select * from USE_CONSTRAINT    );
  drop table SAVE_VER_COORD_SYS     ;
create table SAVE_VER_COORD_SYS     as (select * from VER_COORD_SYS     );
--
spool off
