DIMINUIR TAMANHO DO BANCO

delete from transacao where trndat<='31.12.2024'

delete from notafiscal where trndat<='31.12.2024'

delete from itevda where trndat<='31.12.2024'

delete from ocorrencia_pdv where trndat<='31.12.2024'

delete from transacaotefdll where trndat<='31.12.2024'

delete from documento_nao_fiscal_emitido where trndat<='31.12.2024'

delete from item_nota_fiscal where trndat<='31.12.2024'

delete from transacao_xmlnota where trndat<='31.12.2024'

delete from transacao_xmllog where trndat<='31.12.2024'

delete from finalizacao where trndat<='31.12.2024'

delete from SCANNTECHLOGPRO s            where s.scpdat<='31.12.2025';

delete from PRODUTO_TERMINAL;

delete from SCANNTECHLOGPRO s            where s.scpdat is null

delete from speddoc                      where SPDDATINC <='31.12.2025';

delete from ESTOQUE_MOVIMENTACAO         where movdat <='31.12.2025'; 

delete from PLANO_CONTAS_LANCAMENTO

delete from LOGENVIOTRANSACAO