Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to store a table in memory only?

Re: How to store a table in memory only?

From: Jim <no-spam_at_no-spam.org>
Date: Mon, 22 Jan 2001 14:15:40 -0800
Message-ID: <r7cp6tog8jouncg0vmrhdm91sgtgs0ai8q@4ax.com>

ALTER TABLE <table name> CACHE;

On 22 Jan 2001 06:38:43 GMT, hartgeorge_at_aol.com (Hartgeorge) wrote:

>Hi,
>
>I cannot figure out how to create a table that is stored only in memory.
>Basically I am looking for the mysql equiv of:
> create table foo(x char(2)) type=heap;
>
>Any ideas?
>Thank you- George Hart.
>
Received on Mon Jan 22 2001 - 16:15:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US