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!