ORACLE process, with the help of the custom of a few temporary table TEMP1, will remove the TEMP1 in logic implementation, and insert the data again.
So before the development of the use of the delete from temp1.
Initially didn't find any other problem. But a recent project frequently report "is trying to access is using a temporary table". Under the baidu delete slowly,. It is recommended to use truncate table.
Is really solved the problem. But in the use of truncate table, and brings another problem, perform truncate table will bring the commit, stored procedures in the event of such abnormal logic need to roll back, can not be rolled back again.

For advice on what method can speed up the delete table truncate or can control the speed of the table is not automatically commit?

CodePudding user response:

No one...

CodePudding user response:

Is to delete table, or delete the data in the table?

CodePudding user response:

How many temporary table data? Truncate table must be submitted and cannot be changed

CodePudding user response:

The content of the delete table operation to a process, called this process, delete in either partial submission or truncate

CodePudding user response:

The building Lord said temporary table is temporary table?