Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

tables in memory ram oracle 10gr2

Posted on 2007-12-06
4
Medium Priority
?
1,849 Views
Last Modified: 2013-12-18
i would like to know it's possible have a table in memory ram
0
Comment
Question by:yerai
  • 2
4 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 20419414
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
 
LVL 74

Expert Comment

by:sdstuber
ID: 20419445
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question