tables in memory ram oracle 10gr2

i would like to know it's possible have a table in memory ram
yeraiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sdstuberConnect With a Mentor Commented:
yes, they are called "global temporary tables"


create global temporary table my_temp_table
(
    n  number,
    d  date,
    v  varchar2(20)
)
on commit preserve rows;
0
 
sdstuberCommented:
you can also declare them "on commit delete rows"

the "on commit" settings do just what they sound like and the same action is taken on a rollback.
So,  on commit delete rows,  will also delete the rows when you rollback.

In both cases, the data is lost when the session ends.  Also note,  the data is only visible to the session that creates it.

So, if you insert into the above temp table and I insert into the above temp table,  you only see your data and I only see my data.  Even if we both commit.
0
All Courses

From novice to tech pro — start learning today.