netadmin:
slightly modified your script listed within your dba article and executed the script on a table that has duplicates, however, received the attached error. please respond with a possible solution. i would like to determine the duplicate data, and then modify the same sql to delete the duplicates. thank you in advance for your help.
dr. james s. logan
/export/home/oracle/SCRIPTS>more duprow.sql
SELECT
LFPFX,
LFKEY,
CDATA
FROM
SSYSTEM A
WHERE
rowid >(SELECT min(rowid) FROM SSYSTEM B
WHERE
B.LFPFX = A.LFPFX
and
B.LFKEY = A.LFKEY
and
B.CDATA = A.CDATA
);
————————————————log——————————————–
SQL> @duprow.sql
B.CDATA = A.CDATA
*
ERROR at line 15:
ORA-00997: illegal use of LONG datatype
SQL> quit