Oracle Global Temp table - data is truncated but the table remains in the DB ! is this an expected behavior or a configuration?

by Guru vyas V   Last Updated July 12, 2019 18:06 PM

We are trying to create global temp table using

    Create global Temporary table t1 ( id NUMBER, description VARCHAR2(20) ) 
ON COMMIT Delete Rows;

and trying to drop it at the end manually but the temp table created cannot be dropped by after but the session the data is truncated at the end.

  1. Not able to drop it - is this how oracle works with GTT ?
  2. What are the alternatives ??

Related Questions

SQL - global temporary table vs normal table

Updated September 16, 2019 08:06 AM