I need to delete orphan data from a table with 682 million records.
When execute the following delete statement I receive "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2':
DELETE FROM afl WHERE NOT EXISTS
( SELECT 1 FROM fty WHERE ftykeyi = afl.aflftykeyi );
I know that I can continue to add datafiles. Is there a better way to write the statement or any other suggestions?