30 lines
1.1 KiB
SQL
30 lines
1.1 KiB
SQL
alter table MNP_BIT_OUT_REC rename to MNP_BIT_OUT_REC_OLD;
|
|
alter table MNP_CCRM_NOTIFICA_OUT rename to MNP_CCRM_NOTIFICA_OUT_OLD;
|
|
alter table MNP_CIRCE_OUT rename to MNP_CIRCE_OUT_OLD;
|
|
alter table MNP_CIRCE_OUT_REC rename to MNP_CIRCE_OUT_REC_OLD;
|
|
|
|
alter table MNP_BIT_OUT_REC_NEW rename to MNP_BIT_OUT_REC;
|
|
alter table MNP_CCRM_NOTIFICA_OUT_NEW rename to MNP_CCRM_NOTIFICA_OUT;
|
|
alter table MNP_CIRCE_OUT_NEW rename to MNP_CIRCE_OUT;
|
|
alter table MNP_CIRCE_OUT_REC_NEW rename to MNP_CIRCE_OUT_REC;
|
|
|
|
PROMPT RECORD MNP_BIT_OUT OLD E NEW
|
|
SELECT COUNT(*) NUM_REC FROM MNP_BIT_OUT_REC_OLD
|
|
UNION
|
|
SELECT COUNT(*) NUM_REC FROM MNP_BIT_OUT_REC;
|
|
|
|
PROMPT RECORD MNP_CCRM_NOTIFICA_OUT OLD E NEW
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CCRM_NOTIFICA_OUT_OLD
|
|
UNION
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CCRM_NOTIFICA_OUT;
|
|
|
|
PROMPT RECORD MNP_CIRCE_OUT OLD E NEW
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CIRCE_OUT_OLD
|
|
UNION
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CIRCE_OUT;
|
|
|
|
PROMPT RECORD MNP_CIRCE_OUT_REC OLD E NEW
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CIRCE_OUT_REC_OLD
|
|
UNION
|
|
SELECT COUNT(*) NUM_REC FROM MNP_CIRCE_OUT_REC;
|