There is a create table syntax which failed after executing with below error.
I removed NOLOOGING PARALLEL and it worked i dont understand what actually this NO LOOGING parrlel did in solvong the problem.
CREATE TABLE test_table NOLOGGING PARALLEL AS
select --+ USE_NL(t,x)
trim(replace(function1(CASE WHEN x.mbs_pymnt_method_cd = 2 THEN trim(ttid) ELSE NULL END),',','|')) ttid
FROM result_table t LEFT JOIN
(select trim(tender_type_cd) tender_type_cd, trim(mbs_pymnt_method_cd) mbs_pymnt_method_cd, trim(mbs_credit_card_type) mbs_credit_card_type
from cust
WHERE nvl(pos_pfs_flag,'X') = 'X'
) x
ON (trim(t.tttyp) = x.tender_type_cd)
WHERE t.trans_to_date <= pref.client_date
GROUP BY tt_date, tt_stor, tt_reg, tt_pos;
ERROR at line 1: ORA-12801: error signaled in parallel query server P024, ORA-22922: nonexistent LOB value
function1 is a function defined as below
create or replace
FUNCTION function1(input clob) RETURN clob
PARALLEL_ENABLE AGGREGATE USING LLOVImpl;