
SET AUTOTRACE ON STATISTICS;
SET TIMING ON;

 CREATE TABLE SALES_BKP1
   ("PROD_ID" NUMBER, 
	"CUST_ID" NUMBER, 
	"TIME_ID" DATE, 
	"CHANNEL_ID" NUMBER, 
	"PROMO_ID" NUMBER, 
	"QUANTITY_SOLD" NUMBER(10,2), 
	"AMOUNT_SOLD" NUMBER(10,2)
   );

INSERT INTO SALES_BKP1
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP;

COMMIT;

DROP TABLE SALES_BKP1 ;

CREATE TABLE SALES_BKP1 AS
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP
UNION ALL
SELECT * FROM SALES_BKP;


