Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-1652 on a Permanent Tablespace

aDBAJun 27 2013 — edited Jun 27 2013

In one of our databases, we periodically receive ORA-1652 error, as shown below.

ORA-1652: unable to extend temp segment by 128 in tablespace                 DATAPART_1

DATAPART_1 is not a temporary tablespace. It is a permanent tablespace holding partitioned data. The only segment type in this tablespace is TABLE PARTITION. The error happens when (sometimes but not always) the application loads batch data into the table partitions into the tablespace.

I understand index rebuild may cause ora-1652 in a permanent tablespace, but we did not rebuild any indexes and the tablespace does not have any index objects in it.

Does anyone have an idea what can cause this problem?

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2013
Added on Jun 27 2013
4 comments
1,662 views