hi ,
I have two tables report and report_old having same table structure.Data in both is different.Some rows are common in both while others are different.
MSISDN NUMBER,
EXPIRY_DATE DATE,
VAL_BKT VARCHAR2(4000),
ACCT_BALANCE NUMBER,
BAL_BKT VARCHAR2(4000)
I want to get to get all the msisdn in report table that are not in the report_old table.I use below query for that but its taking long time execute.
create table report_ins
as
(select *From report
where msisdn not in (select msisdn from report_old));
Both the table contain more than 360000 rows of data .
Plz help.