10 Replies Latest reply: Aug 2, 2012 6:44 AM by Purvesh K RSS

    Where Oracle stores temporary tables data?

      Suppose, I am in session a,

      I have created following GTT table=>

      create global temporary table tt_test
      Fname varchar2(20), Lname varchar2(20);
      on commit preserve rows;

      Inserting data into GTT=>

      insert into tt_test values ('john','smith');

      Commit the session=>

      Now I have opened another session b, and I want to see the data of tt_test table from another session.

      How I can acheive it as long as sesssion a is active?