Template de delete das tabelas de cadastros e movimentos do ERP quando precisar sincronizar uma base que já iniciou as atividades sem planejamento
de sincronização.
Não será feito no padrão SNKScript porque depende muito de cada caso
*/
DELETE FROM TGFITE
DELETE FROM TGFITE_EXC
DELETE FROM TGFCAB WHERE TIPMOV <> 'Z'
DELETE FROM TGFCAN
DELETE FROM TGFCAB_EXC
DELETE FROM TGFVAR
DELETE FROM TGFFIN
DELETE FROM TGFFIN_EXC
DELETE FROM TGFRAT
DELETE FROM TGFFRE
DELETE FROM TGFREN
DELETE FROM TGFMBC
DELETE FROM TGFMBC_EXC
DELETE FROM TCBLAN
TRUNCATE TABLE TSILRE
TRUNCATE TABLE TSILAC
DELETE FROM TGFDIN
DELETE FROM TGFLIV
DELETE FROM TGFLIV_EXC
DELETE FROM TSILOG
DELETE FROM TGFTRC
DELETE FROM TGFEST
DELETE FROM TGFLNF
DELETE TGFCAI
DELETE TGFMCX
DELETE TFPFOL
DELETE TFPLOG
DELETE TCBSAL
TRUNCATE TABLE AUDIT_DDL_TRG;
DELETE FROM TGFNFE
DELETE FROM TGFTEL
DELETE FROM TSILIB
DELETE FROM TSISNL
/*
Tabelas de cadastro do datasync
Por segurança melhor limpar as tabelas do datasync, pelo fato de pegar uma base que já sincronizava, quando não pegar uma base já sincronizada
não precisa rodar essa parte.
*/
DELETE FROM TSDFTI;
DELETE FROM TSDINO;
DELETE FROM TSDLNE;
DELETE FROM TSDNUM;
DELETE FROM TSDPLC;
DELETE FROM TSDPAR;
DELETE FROM TSDPLF;
DELETE FROM TSDPLT;
DELETE FROM TSDTBI;
DELETE FROM TSDPLA;
DELETE FROM TSDPAC;
/*
Triggers do datasync
Por segurança melhor limpar as tabelas do datasync, pelo fato de pegar uma base que já sincronizava, quando não pegar uma base já sincronizada
não precisa rodar essa parte.
Comando para criar o script abaixo para dropar as triggers do DataSync Base Matriz, quando pegar uma base que já foi sincronizada
SELECT 'DROP TRIGGER ' || OBJECT_NAME || ';' FROM USER_OBJECTS WHERE object_name LIKE 'TRG_DTSYNC%' AND OBJECT_TYPE = 'TABLE'
Apos gerar execute pelo toad
*/
DROP TRIGGER TRG_DTSYNC_TCBDEM;
DROP TRIGGER TRG_DTSYNC_TCBEMP;
DROP TRIGGER TRG_DTSYNC_TCBHIS;
DROP TRIGGER TRG_DTSYNC_TCBPLA;
DROP TRIGGER TRG_DTSYNC_TCSPRJ;
DROP TRIGGER TRG_DTSYNC_TGFCAB;
DROP TRIGGER TRG_DTSYNC_TGFCFO;
DROP TRIGGER TRG_DTSYNC_TGFCMB;
DROP TRIGGER TRG_DTSYNC_TGFCPL;
DROP TRIGGER TRG_DTSYNC_TGFCTT;
DROP TRIGGER TRG_DTSYNC_TGFCUS;
DROP TRIGGER TRG_DTSYNC_TGFDIN;
DROP TRIGGER TRG_DTSYNC_TGFEMP;
DROP TRIGGER TRG_DTSYNC_TGFEXC;
DROP TRIGGER TRG_DTSYNC_TGFFDM;
DROP TRIGGER TRG_DTSYNC_TGFGRA;
DROP TRIGGER TRG_DTSYNC_TGFGRU;
DROP TRIGGER TRG_DTSYNC_TGFHBC;
DROP TRIGGER TRG_DTSYNC_TGFICM;
DROP TRIGGER TRG_DTSYNC_TGFIMA;
DROP TRIGGER TRG_DTSYNC_TGFIMC;
DROP TRIGGER TRG_DTSYNC_TGFIPI;
DROP TRIGGER TRG_DTSYNC_TGFITE;
DROP TRIGGER TRG_DTSYNC_TGFLNF;
DROP TRIGGER TRG_DTSYNC_TGFLOC;
DROP TRIGGER TRG_DTSYNC_TGFNAT;
DROP TRIGGER TRG_DTSYNC_TGFNTA;
DROP TRIGGER TRG_DTSYNC_TGFOBS;
DROP TRIGGER TRG_DTSYNC_TGFPAL;
DROP TRIGGER TRG_DTSYNC_TGFPAP;
DROP TRIGGER TRG_DTSYNC_TGFPAR;
DROP TRIGGER TRG_DTSYNC_TGFPPA;
DROP TRIGGER TRG_DTSYNC_TGFPPG;
DROP TRIGGER TRG_DTSYNC_TGFPRO;
DROP TRIGGER TRG_DTSYNC_TGFREP;
DROP TRIGGER TRG_DTSYNC_TGFRGV;
DROP TRIGGER TRG_DTSYNC_TGFRPV;
DROP TRIGGER TRG_DTSYNC_TGFSTG;
DROP TRIGGER TRG_DTSYNC_TGFTAB;
DROP TRIGGER TRG_DTSYNC_TGFTCF;
DROP TRIGGER TRG_DTSYNC_TGFTIT;
DROP TRIGGER TRG_DTSYNC_TGFTOP;
DROP TRIGGER TRG_DTSYNC_TGFTPP;
DROP TRIGGER TRG_DTSYNC_TGFTPV;
DROP TRIGGER TRG_DTSYNC_TGFVAR;
DROP TRIGGER TRG_DTSYNC_TGFVEI;
DROP TRIGGER TRG_DTSYNC_TGFVEN;
DROP TRIGGER TRG_DTSYNC_TGFVOA;
DROP TRIGGER TRG_DTSYNC_TGFVOL;
DROP TRIGGER TRG_DTSYNC_TSIAGE;
DROP TRIGGER TRG_DTSYNC_TSIBAI;
DROP TRIGGER TRG_DTSYNC_TSIBCO;
DROP TRIGGER TRG_DTSYNC_TSICEP;
DROP TRIGGER TRG_DTSYNC_TSICID;
DROP TRIGGER TRG_DTSYNC_TSICTA;
DROP TRIGGER TRG_DTSYNC_TSICUS;
DROP TRIGGER TRG_DTSYNC_TSIEMP;
DROP TRIGGER TRG_DTSYNC_TSIEND;
DROP TRIGGER TRG_DTSYNC_TSIGRU;
DROP TRIGGER TRG_DTSYNC_TSIMOE;
DROP TRIGGER TRG_DTSYNC_TSIPAI;
DROP TRIGGER TRG_DTSYNC_TSIPER;
DROP TRIGGER TRG_DTSYNC_TSIREG;
DROP TRIGGER TRG_DTSYNC_TSIUFS;
DROP TRIGGER TRG_DTSYNC_TSIUSU;
DROP TRIGGER TRG_DTSYNC_TWUSU;
/*
Tabelas de movimento do datasync
Por segurança melhor limpar as tabelas do datasync, pelo fato de pegar uma base que já sincronizava, quando não pegar uma base já sincronizada
não precisa rodar essa parte.
Comando para criar o script abaixo para dropar as tabelas do DataSync Base Matriz, quando pegar uma base que já foi sincronizada
SELECT 'DROP TABLE ' || OBJECT_NAME || ';' FROM USER_OBJECTS WHERE object_name LIKE 'SYNC%' AND OBJECT_TYPE = 'TABLE'
Apos gerar execute pelo toad
*/
DROP TABLE SYNC_TCBDEM;
DROP TABLE SYNC_TCBEMP;
DROP TABLE SYNC_TCBHIS;
DROP TABLE SYNC_TCBPLA;
DROP TABLE SYNC_TCSPRJ;
DROP TABLE SYNC_TGFCAB;
DROP TABLE SYNC_TGFCFO;
DROP TABLE SYNC_TGFCMB;
DROP TABLE SYNC_TGFCPL;
DROP TABLE SYNC_TGFCTT;
DROP TABLE SYNC_TGFCUS;
DROP TABLE SYNC_TGFDIN;
DROP TABLE SYNC_TGFEMP;
DROP TABLE SYNC_TGFEXC;
DROP TABLE SYNC_TGFFDM;
DROP TABLE SYNC_TGFGRA;
DROP TABLE SYNC_TGFGRU;
DROP TABLE SYNC_TGFHBC;
DROP TABLE SYNC_TGFICM;
DROP TABLE SYNC_TGFIMA;
DROP TABLE SYNC_TGFIMC;
DROP TABLE SYNC_TGFIPI;
DROP TABLE SYNC_TGFITE;
DROP TABLE SYNC_TGFLNF;
DROP TABLE SYNC_TGFLOC;
DROP TABLE SYNC_TGFNAT;
DROP TABLE SYNC_TGFNTA;
DROP TABLE SYNC_TGFOBS;
DROP TABLE SYNC_TGFPAL;
DROP TABLE SYNC_TGFPAP;
DROP TABLE SYNC_TGFPAR;
DROP TABLE SYNC_TGFPPA;
DROP TABLE SYNC_TGFPPG;
DROP TABLE SYNC_TGFPRO;
DROP TABLE SYNC_TGFREP;
DROP TABLE SYNC_TGFRGV;
DROP TABLE SYNC_TGFRPV;
DROP TABLE SYNC_TGFSTG;
DROP TABLE SYNC_TGFTAB;
DROP TABLE SYNC_TGFTCF;
DROP TABLE SYNC_TGFTIT;
DROP TABLE SYNC_TGFTOP;
DROP TABLE SYNC_TGFTPP;
DROP TABLE SYNC_TGFTPV;
DROP TABLE SYNC_TGFVAR;
DROP TABLE SYNC_TGFVEI;
DROP TABLE SYNC_TGFVEN;
DROP TABLE SYNC_TGFVOA;
DROP TABLE SYNC_TGFVOL;
DROP TABLE SYNC_TSIAGE;
DROP TABLE SYNC_TSIBAI;
DROP TABLE SYNC_TSIBCO;
DROP TABLE SYNC_TSICEP;
DROP TABLE SYNC_TSICID;
DROP TABLE SYNC_TSICTA;
DROP TABLE SYNC_TSICUS;
DROP TABLE SYNC_TSIEMP;
DROP TABLE SYNC_TSIEND;
DROP TABLE SYNC_TSIGRU;
DROP TABLE SYNC_TSIMOE;
DROP TABLE SYNC_TSIPAI;
DROP TABLE SYNC_TSIPER;
DROP TABLE SYNC_TSIREG;
DROP TABLE SYNC_TSIUFS;
DROP TABLE SYNC_TSIUSU;
DROP TABLE SYNC_TWUSU;
Nenhum comentário:
Postar um comentário