create table customer(...as select from an external table) * ERROR at line 1: ORA-12801: error signaled in parallel query server P001 ORA-01652: unable to extend temp segment by 128 in tablespace TPCH10The tablespace in question has 2.5 gig free with the largest free extent 45 meg and a block size of 8k. We have set parallel_max_servers to 20.
Why am I getting this error? I have a TEMP tablespace and the user where I am running this has TEMP set as the temporary tablespace. I checked user_users to confirm and restarted the database just to make sure. I read something about hash-joins causing this error, but it does not seem to explain this simple select from an external table.
"unable to extend temp segment by 128 in tablespace TPCH10"
Notice that your error message indicates that the problem is in the TPCH10 tablespace, not the TEMP tablespace. A temporary segment in this tablespace is trying to allocate space in this tablespace and needs 128 more bytes to complete the allocation. So you'll need more space in the TPCH10 tablespace.
Some permanent segments, like indexes, start off as temporary segments and are then made permanent by the database once the segment has been created. So if you are creating an index when creating the table, it needs space for the index creation in this tablespace as well.