I have an INSERT statement with a complex SELECT as given below. When I run this, it waits for some time then gives error: 'Unable to extend temporary segment by 64' and fails. I suspect that the problem is about SELECT part with joins. I need your help for how I can get around this problem and how I can eliminate such problematic joins?
INSERT INTO /*+ PARALLEL NOLOGGING */ SCHEMAX.MRN_GFLD (select CURRENCY_DATE, TM.TMNAME || '|' || CM.FLDNO as CMCUR, CM.* from SCHEMAY.MRN_GFLD CM, SCHEMAY.MRN_GTM TM where CM.TMID=TM.TMID and CM.CSB=TM.CSB );