extracting unique fields from 2 tables into one new table

Hi All,
I'm trying to extract every unique field 'called MESSAGES' that exists in table LDR2 and not in table LDR into a new table UNIQUE (each table has only 2 fields (MESSAGES<CLOB>,ID<NUMBERIC>). We missed some data initially, now the LDR2 has the missing data. I need to get this missing data in LDR2 into the new table . However, I cant seem to run many commands because its a CLOB -datatypes.

I'm Using SQL-PLUS - Oracle9i Release 9.2.0.1.0.

<My query that doesnt seem to be working fully> insert into seebeyond.RAD_MESSAGES_UNIQUE (SELECT seebeyond.RAD_MESSAGES_LDR2.MESSAGES, seebeyond.RAD_MESSAGES_LDR2.ID FROM seebeyond.RAD_MESSAGES_LDR2, seebeyond.RAD_MESSAGES_LDR WHERE seebeyond.RAD_MESSAGES_LDR2.MESSAGES NOT LIKE seebeyond.RAD_MESSAGES_LDR.MESSAGES and (rownum < 33617)) /

-Thanks for any advise,
CarlS Received on Tue Apr 03 2007 - 18:56:36 CDT