Ora-01653 temp is not big enough to solve the problem

When we re-index a table of about 70 GB, we found that the ora 1653 error would be reported. The problem is that the temp break is not large enough, because sorting is required during index creation, as a result, a large number of temp segments are used, so we use the method of specifying the temp segment.

As follows:

1. CreateBigfileTemporaryTablespace temp_botnet
2. Tempfile'D:/temp_botnet.dbf'
3. Size1024 m
4. AutoextendOn
5. Next1024 m
6. Extent managementLocal;
9. ALTER USERSZHAOTEMPORARYTABLESPACE temp_botnet

The essence is to create a tablespace of the bigfile temporary tablespace, and then re-specify

ALTER USERSZHAOTEMPORARYTABLESPACE temp_botnet

We recommend that you use the bigfile field when creating a tablespace for your temp space, because Oracle supports up to 30 GB of single files in a 32-bit system.