title: Pentaho Spoon transformation throws: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
body: <p>Hey I'm doing a simple transformation with Pentaho Spoon, the transformation has two steps:</p>
  <ol>
  <li><p><strong>Input table:</strong> I use a SQL to extract the data from an Oracle 11g database.</p>
  </li>
  <li><p><strong>Excel Output:</strong> I write the data from the database in an excel file.</p>
  </li>
  </ol>
  <p>The problem is when I try to run this 2 steps transformation, nothing is happening. I tried to visualize the first 200 entries from the first step but throws the following error:</p>
  <p><em>ORA-01652: unable to extend temp segment by 128 in tablespace TEMP.</em></p>
  <p>Is this the reason why the transformation doesn't work, how I could fix it, having into account that I don't have admin privileges into the database to increase the TEMP tablespace size.</p>
  <p>These are the Loggin messages:</p>
  <p><a href="https://i.stack.imgur.com/PxXFi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PxXFi.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/bO68y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bO68y.png" alt="enter image description here" /></a></p>
  <p>The query used in the input table method is as follows:</p>
  <pre><code>SELECT
  ptn.ptnID,
  ptn.ptnNAME,
  ptn.ptnSURNAME,
  ptn.SSN,
  ptn.EXTERNALID,
  ptn.NTS,
  ptn.GENDER,
  ptn.DOB,
  ptn.ADDRESS,
  ptn.CITY,
  ptn.STATE,
  ptn.COUNTRY,
  ptn.POSTALCODE,
  ptn.ACTIVE,
  ptn.NACIONALITY,
  ptn.COUNTRYOFBIRTH,
  ptn.EXITUS,
  ptn.ptnFIRSTSURNAME,
  ptn.ptnSECONDSURNAME,
  ptn.DEATHDATE,
  appl.applID,
  srv.srvDESCRIPTION,
  center.CENTERDESCRIPTION,
  appl.applLABEL,
  appl.applDATE,
  appl.COMPLETEDATE,
  container.COMMENTS,
  sample.SAMPLEDESCRIPTION,
  test.TESTDESCRIPTION,
  test.UNITSCS,
  rslhst.RESULTSTATUS,
  rslhst.ISAUTOMATIC,
  pathology.PATHOLOGYDESCRIPTION,
  FROM USRGR.APPLICATION appl
  LEFT OUTER JOIN USRGR.PTN ptn on ptn.ptnid = appl.ptnid
  LEFT OUTER JOIN USRGR.APPLICATIONTEST appltest on appltest.ptnid = appl.ptnid
  LEFT OUTER JOIN USRGR.TEST test on test.testid = appltest.testid
  LEFT OUTER JOIN USRGR.RSLHST rslhst on (rslhst.applid = appltest.applid) AND (rslhst.testid = appltest.testid)
  LEFT OUTER JOIN USRGR.CONTAINER container on container.containerid = rslhst.containerid
  LEFT OUTER JOIN USRGR.DOC doc on doc.docid = appl.docid
  LEFT OUTER JOIN USRGR.SRV srv on srv.srvid = appl.srvid
  LEFT OUTER JOIN USRGR.CENTER center on center.centerid = srv.centerid
  LEFT OUTER JOIN USRGR.SAMPLE sample on  sample.sampleid = container.sampleid
  LEFT OUTER JOIN USRGR.CLTRISOL  cltrisol on  cltrisol.applid = rslhst.applid
  LEFT OUTER JOIN USRGR.ISL isl on isl.islid = cltrisol.islid
  LEFT OUTER JOIN USRGR.PATHOLOGY on pathology.pathologyid = rslhst.pathology
  LEFT OUTER JOIN USRGR.COD cod on cod.codsfamilyid = rslhst.codsfamilyid AND rslhst.shortdescription1 = cod.shortdescription
  LEFT OUTER JOIN USRGR.INTERVALS intervals on intervals.testid = test.testid AND intervals.methodid = rslhst.methodid
  WHERE
      appl.orderdate BETWEEN '01/01/19' AND '02/01/19' AND
      rslhst.isfinal = 'Y' AND
      appl.iscomplete = 'Y' AND
      ((to_number(to_char(appl.ORDERDATE, 'YYYY')) - to_number(to_char(ptn.DOB, 'YYYY'))) * 12 * 12 &gt;= intervals.from) AND
      ((to_number(to_char(appl.ORDERDATE, 'YYYY')) - to_number(to_char(ptn.DOB, 'YYYY'))) * 12 * 12 &lt; intervals.to) AND
      test.testid in (
      5, 5261,
      435, 438,
      5014, 3986, 3987,
      4293, 6017, 2295, 2296, 2298,
      196, 199, 218, 219, 1626, 3861, 5275, 5276
      );
  </code></pre>
  <p>Explain Plan output:</p>
  <pre><code>&quot;PLAN_TABLE_OUTPUT&quot;
  
  &quot;Plan hash value: 3813514414&quot;
  
  &quot; &quot;
  
  &quot;-------------------------------------------------------------------------------&quot;
  
  &quot;| Id  | Operation     | Name                 | Rows  | Bytes |TempSpc| Cost  | &quot;
  
  &quot;-------------------------------------------------------------------------------&quot;
  
  &quot;|   0 | SELECT STATEMENT  |                  |   319K|   497M|       |  1508K|&quot;
  
  &quot;|*  1 |  FILTER           |                  |       |       |       |       |&quot;
  
  &quot;|*  2 |   HASH JOIN OUTER |                  |   319K|   497M|   494M|  1508K|&quot;
  
  &quot;|   3 |    VIEW           |                  |   319K|   490M|       |  1500K|&quot;
  
  &quot;|*  4 |     FILTER        |                  |       |       |       |       |&quot;
  
  &quot;|*  5 |      HASH JOIN OUTER|                |   319K|   172M|   148M|  1500K|&quot;
  
  &quot;|*  6 |       HASH JOIN OUTER|               |   319K|   145M|   140M|  1491K|&quot;
  
  &quot;|*  7 |        HASH JOIN OUTER|              |   319K|   137M|   116M|  1489K|&quot;
  
  &quot;|*  8 |         HASH JOIN OUTER|             |   319K|   112M|   105M|  1487K|&quot;
  
  &quot;|*  9 |          HASH JOIN OUTER|            |   319K|   101M|    88M|  1485K|&quot;
  
  &quot;|* 10 |           HASH JOIN OUTER|           |   284K|    85M|    79M|  1483K|&quot;
  
  &quot;|* 11 |            HASH JOIN OUTER|          |   284K|    76M|    74M|  1482K|&quot;
  
  &quot;|* 12 |             HASH JOIN|               |   284K|    71M|   148M|  1481K|&quot;
  
  &quot;|* 13 |              FILTER|                 |       |       |       |       |&quot;
  
  &quot;|* 14 |               HASH JOIN OUTER|       |   669K|   141M|   121M| 89111 |&quot;
  
  &quot;|  15 |                NESTED LOOPS OUTER|   |   669K|   114M|       | 87134 |&quot;
  
  &quot;|* 16 |                 HASH JOIN OUTER|     |  1616 |   257K|       | 22494 |&quot;
  
  &quot;|* 17 |                  HASH JOIN OUTER|    |  1616 |   211K|       | 22479 |&quot;
  
  &quot;|* 18 |                   HASH JOIN OUTER|   |  1616 |   173K|       | 22474 |&quot;
  
  &quot;|* 19 |       TABLE ACCESS FULL| APPLICATION |  1616 |   123K|       | 22469 |&quot;
  
  &quot;|  20 |       TABLE ACCESS FULL| SERVICE     |   292 |  9344 |       |     3 |&quot;
  
  &quot;|  21 |       TABLE ACCESS FULL| CENTER      |    16 |   384 |       |     3 |&quot;
  
  &quot;|  22 |       TABLE ACCESS FULL| DOC         |  7154 |   202K|       |    12 |&quot;
  
  &quot;|  23 |TABLE ACCESS BY INDEX ROWID| APPLICATIONTEST|414 |  6624 |    |    40 |&quot;
  
  &quot;|* 24 |INDEX RANGE SCAN| RQTEST_PTNID_IDX    |   414 |       |       |     3 |&quot;
  
  &quot;|  25 |TABLE ACCESS FULL       | TEST        |  4292 |   176K|       |    31 |&quot;
  
  &quot;|* 26 |TABLE ACCESS FULL       | RSLHST      |   187M|  7686M|       |  1233K|&quot;
  
  &quot;|  27 |TABLE ACCESS FULL       | PATHOLOGY   |    45 |   720 |       |     3 |&quot;
  
  &quot;|  28 |TABLE ACCESS FULL       | COD         |  4289 |   142K|       |    14 |&quot;
  
  &quot;|  29 |TABLE ACCESS FULL       | CLTRISOL    |   212K|  4144K|       |   505 |&quot;
  
  &quot;|  30 |TABLE ACCESS FULL       | ISL         |  2303 | 80605 |       |     6 |&quot;
  
  &quot;|  31 |TABLE ACCESS FULL       | CONTAINER   |   674 | 53920 |       |     5 |&quot;
  
  &quot;|  32 |TABLE ACCESS FULL       | SAMPLE      |   354 |  9558 |       |     2 |&quot;
  
  &quot;|  33 |TABLE ACCESS FULL       | PTN         |  1886K|   160M|       |  3887 |&quot;
  
  &quot;|  34 |TABLE ACCESS FULL       | MARGINS     |  2232 | 49104 |       |     8 |&quot;
  
  &quot;-------------------------------------------------------------------------------&quot;
  </code></pre>