The Oracle temporary Table is not temporary!?
804709Feb 23 2011 — edited Feb 23 2011When I run the following script:
CREATE TEMPORARY TABLE my_temp_table (
column1 NUMBER,
column2 NUMBER
) ON COMMIT DELETE ROWS;
the table my_temp_table exists in another session!!
and also exists even the session close!!
(Oracle is 9i)
Edited by: Dever on 2011/2/22 下午 11:14