Q
Problem solve Get help with specific problems with your technologies, process and projects.

Errors during building of tables

I am getting two errors while building the tables for a 20G TPCH Benchmark. The 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 am getting two errors while building the tables for a 20G TPCH Benchmark:
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 TPCH10
The 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.

Please look at your error message carefully:

"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.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close