Analysis of temporary tables and truncate errors in Oracle

There was a problem with the system last night, a stored procedure was performing an exception, and observation only found that the higher the logic read. When the situation was more urgent, I had to change the original into the old way.

In fact, the changes are very simple, the new is as follows:

EXECUTE IMMEDIATE 'TRUNCATE TABLE temp_test REUSE STORAGE ‘ ;

The old ones are as follows:

delete from TEMP_TEST ;

Temp_test is a temporary table.

This morning the test found that the temporary table was different from the normal table when truncate.

The test experiment is as follows:

sleect * from v$version
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
CREATE GLOBAL TEMPORARY TABLE TEMP_TEST
(
TEST_ID VARCHAR2(30 BYTE) NOT NULL,
TEST_COUNT NUMBER(10)
)
ON COMMIT PRESERVE ROWS
NOCACHE;