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.
- Not able to drop it - is this how oracle works with GTT ?
- What are the alternatives ??