the query is

select segment_name "trafr_seg", partition_name
from dba_segments a
where segment_name not in
(
select segment_name from dba_segments@trafp b
where tablespace_name='INTERCON_ADD_D'
and a.segment_name=b.segment_name
)
and tablespace_name='INTERCON_ADD_D'
where tablespace_name='INTERCON_ADD_D'
*
ERROR at line 6:
ORA-00920: invalid relational operator
ORA-02063: preceding line from TRAFP

is exactly the same as the other one just with an extra NOT before in

I think it is compianing about the

where tablespace_name='INTERCON_ADD_D'

in the subquery


But I dont see why... I am puzzled


Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
on Tru64