Error Caused by tablespace _ temporary tablespace: ora-01652 small example, ora-01652

Error Caused by tablespace _ temporary tablespace: ora-01652 small example, ora-01652

Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46888243

Error Reporting temporary tablespace Insufficiency: ora-01652

When performing the insert operation, the following error is reported: the temporary tablespace is insufficient.

The error message is as follows:

View the extended temporary tablespace, which has been automatically extended to 32 GB.

Review the usage of temporary tablespace:

For temporary tablespaces, sorting operations may use temporary tablespaces. When the sort area Memory is insufficient, temporary tablespace is used. For sorting, the create index, order by, and group by operations may all use temporary tablespace when collecting statistics. The sorting operation will first sort in the sort area Memory. Once the memory of the sort area (memory sorting area) is insufficient, the temporary tablespace sort in disk (disk sorting, temporary tablespace ).

The possibility of this error is that you need to create indexes at the same time during insertion, so you need to use a large number of temporary tablespace. In addition, to increase the speed, multiple insert tasks are started in parallel, so the temporary tablespace is insufficient.

 

Solution:

After an error occurs, all data insertion operations are stopped. The plan was adjusted as follows:

1. Expand the size of the temporary tablespace;

2. Reduce the number of parallel tasks;

3. Delete the index. After all data is inserted, re-create the index;

4. After the task is completed, reclaim the temporary tablespace;

 

The first two steps are attempted first, and the problem is successfully avoided:

1. Expand the temporary tablespace to 60 GB.

2. Reduce the concurrency by 4 to 2. Execute the insert action one by one.

Result: The large data volume is successfully inserted.

 

**************************************** * ** Blue growth series ********************************* *******************

Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).

Blue growth note-chasing DBA (1): traveling on the road to Shandong

Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.

Blue growth note-chasing DBA (3): importing and exporting data on antiques becomes a problem

Blue growth note-chasing DBA (4): recalling the sorrow of teenagers, and exploring oracle Installation (10g and 11g in Linux)

Blue growth note-chasing DBA (5): Not talking about technology or business, annoying Application Systems

Blue growth note-chasing DBA (6): doing things and being human: Small technology, great human

Blue growth note-Chase DBA (7): Basic commands, foundation stone

Blue growth notes-chasing DBA (8): repicking SP reports and recalling oracle's STATSPACK Experiment

Blue growth note-chasing DBA (9): Chasing DBA, new planning, new departure

Blue growth note-chasing DBA (10): Flying knife defense, familiarity rather than expertise: Playing with middleware Websphere

Blue growth note-chasing DBA (11): It's easy to go home and wake up.

Blue growth notes-Chase DBA (12): seven days and seven gains of SQL

Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches ......"

Blue growth note-chasing DBA (14): An unforgettable "Cloud" end, started hadoop deployment

Blue growth note-chasing DBA (15): Who thinks FTP is "simple" and thinks it is a trigger

Blue growth note-chasing DBA (16): DBA also drank alcohol and was rejected

Blue growth note-Chase DBA (17): whether to share or consume, learn to grow in the Post-IOE Era

**************************************** **************************************** **********************************

 

**************************************** ******************************** *****************

Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).

Football and oracle series (1): 32-way zhoudianbing, overall view of group A Brazil smon process of oracle32 process Alliance

Football and oracle series (2)

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight!

Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison! 

Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package!

Football and oracle series (6): Asian Cup with database creation-come on, Chinese Team

**************************************** **************************************** **********************************

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.