Obsidian/Recognition/Work Related/프로젝트/스마트계류장/1.데이터베이스/EAI 데이터 백업 테이블 생성.md

create table  UEAI.EAI_AFTNFLTINFO_RCV_OLD as
select *
from UEAI.EAI_AFTNFLTINFO_RCV
where recv_time = 'a';

-- v_proc_item := 'AMOS';
create table UEAI.EAI_AWOS_RCV_OLD as
select *
from UEAI.EAI_AWOS_RCV
where recv_time = 'a' ;

-- v_proc_item := 'NOTAM';
create table UEAI.EAI_ELECSTRIPARRARTS_RCV_OLD as
select *
from UEAI.EAI_ELECSTRIPARRARTS_RCV
where recv_time = 'a' ;

-- v_proc_item := 'ARTS_DEP';
create table UEAI.EAI_ELECSTRIPDEPARTS_RCV_OLD as
select *
from UEAI.EAI_ELECSTRIPDEPARTS_RCV
where recv_time = 'a' ;

-- v_proc_item := 'ACDM_ARR';
create table UEAI.EAI_FLTACDMMLSTNARR_RCV_OLD as
select *
from UEAI.EAI_FLTACDMMLSTNARR_RCV
where recv_time = 'a' ;

-- v_proc_item := 'ACDM_DEP';
create table UEAI.EAI_FLTACDMMLSTNDEP_RCV_OLD as
select *
from UEAI.EAI_FLTACDMMLSTNDEP_RCV
where recv_time = 'a' ;

-- v_proc_item := 'GAM';
create table UEAI.EAI_GRDACMVT_RCV_OLD as
select *
from UEAI.EAI_GRDACMVT_RCV
where recv_time = 'a' ;

-- v_proc_item := 'LLWAS_ALRT';
create table UEAI.EAI_LLWASALRT_RCV_OLD as
select *
from UEAI.EAI_LLWASALRT_RCV
where recv_time = 'a' ;

-- v_proc_item := 'LLWAS_DATA';
create table UEAI.EAI_LLWASDATA_RCV_OLD as
select *
from UEAI.EAI_LLWASDATA_RCV
where recv_time = 'a' ;

-- v_proc_item := 'METAR';
create table UEAI.EAI_METAR_RCV_OLD as
select *
from UEAI.EAI_METAR_RCV
where recv_time = 'a' ;

-- v_proc_item := 'NOTAM';
create table UEAI.EAI_SIGMET_RCV_OLD as
select *
from UEAI.EAI_SIGMET_RCV
where recv_time = 'a' ;

-- v_proc_item := 'SPECIAL';
create table UEAI.EAI_SPECIAL_RCV_OLD as
select *
from UEAI.EAI_SPECIAL_RCV
where recv_time = 'a' ;

-- v_proc_item := 'NOTAM';
create table UEAI.EAI_TDWRDATA_RCV_OLD as
select *
from UEAI.EAI_TDWRDATA_RCV
where recv_time = 'a' ;



-- v_proc_item := 'PROC_LOG';
create table UEAI.SACP_EAI_INTRFC_PROC_LOG_OLD as
select *
from UEAI.SACP_EAI_INTRFC_PROC_LOG
where log_dt = 'a' ;

-- v_proc_item := 'LTEA';
create table UEAI.SACP_INTRFC_LTEA_OLD as
select *
from UEAI.SACP_INTRFC_LTEA
where REGISTER_DT = 'a' ;


ALTER TABLE UEAI.EAI_AFTNFLTINFO_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_AWOS_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_ELECSTRIPARRARTS_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_ELECSTRIPDEPARTS_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_FLTACDMMLSTNARR_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_FLTACDMMLSTNDEP_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_GRDACMVT_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_LLWASALRT_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_LLWASDATA_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_METAR_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_SIGMET_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_SPECIAL_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.EAI_TDWRDATA_RCV_OLD NOLOGGING ;
ALTER TABLE UEAI.SACP_EAI_INTRFC_PROC_LOG_OLD NOLOGGING ;
ALTER TABLE UEAI.SACP_INTRFC_LTEA_OLD NOLOGGING ;