How to get rows that r not common in two tables?

[IrfanNazir]

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.

[mallangouda]

try with this query .. it will reduce the access time but not sure how much.. but it is good query compared to older one.
create table report_ins
as
(select *From report a
where not exists (select b.msisdn from report_old b where a.msisdn=b.msisdn));

[PAVB]

you can do it easily with MINUS operator, follows pseudocode

select * from table_a
minus
select * from table_b
;

[IrfanNazir]

Thanks 'not exists' has improved performance..