针对global temporary table tsa01(id int) on commit preserve rows
1.在当前session drop table时候，必须先truncate该表
2.当另起一个session后，查看该表数据为空。http://www.cndba.cn/hbhe0316/article/107968

SQL> create global temporary table tsa01(id int) on commit preserve rows;

Table created.

SQL> insert into tsa01 values (11);

1 row created.

SQL> select * from tsa01;

        ID
----------
        11

SQL> drop table tsa01;
drop table tsa01
           *
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use


SQL> commit;

Commit complete.

SQL> drop table tsa01;
drop table tsa01
           *
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use


SQL> truncate table tsa01;

Table truncated.

SQL> drop table tsa01;

Table dropped.

[oracle@db02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 3 10:25:37 2022
Version 19.15.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0

SQL> select * from tsa01;

no rows selected

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle