query taking complete temp

Hi,

We have query which is taking complete temp using not like condition when we remove the not like condition its comes out neatly. kindly help.

select a.* from  (select extract,DELGROUP,SOURCE_COMMIT,TARGET_COMMIT,SYSTIMESTAMP,CAPTIME,PMPTIME

from GGS.GGS_HEARTBEAT_HIST)  a,

(select DELGROUP,  max(SOURCE_COMMIT) latest_commit   from GGS.GGS_HEARTBEAT_HIST group by DELGROUP) b

where a.DELGROUP=b.DELGROUP and a.SOURCE_COMMIT=b.latest_commit and a.extract not like 'E0%';

if in the above query we remove the condition the output comes out clearly but not the desired one.

Regards,