SELECT /*+ USE_NL ( vd1 ,vd2 ,vd3  ) leading ( vd1 ,vd2 ,vd3  , tvd) */ vd1.vendor_record_seq_no,
tvr.checksum, tvr.rownumber, tvr.transaction_type, 'U'  
  FROM vendor_data vd1, vendor_data vd2, vendor_data vd3,
  (SELECT  rownumber, MAX (DECODE (control_column_seq_no, 91150, original_value, NULL)) AS value1,
  MAX (DECODE (control_column_seq_no, 91152, original_value, NULL)) AS value2,
  MAX (DECODE (control_column_seq_no, 91141, original_value, NULL)) AS value3
  	  FROM (SELECT /*+ dynamic_sampling(vdt 3) dymanic_sampling_est_cdn(vdt) */ rownumber, 
   		   	VALUE AS original_value,control_column_seq_no
				  FROM temp_vendor_data vdt
				  WHERE vdt.KEY = 'Y' AND error_flag IS NULL) temp 
  GROUP BY rownumber) tvd, temp_vendor_record tvr 
  WHERE vd1.study_seq_no = 25706 AND vd1.control_column_seq_no = 91150

select * from v$session a, v$sql b
   where a.sql_id=b.sql_id
   and status = 'ACTIVE'

01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause:  Failed to allocate an extent of the required number of blocks for
//          a temporary segment in the tablespace indicated.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//          files to the tablespace indicated.

FROM ..., vendor_data vd2, vendor_data vd3