Re: In-memory tables.

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 06 Mar 2000 18:01:18 +0800
Message-ID: <38C381EE.322D@yahoo.com>

Gennadiy Greenberg wrote:
>
> Please, type:
>
> SQL>ALTER TABLE <your_table> CACHE;
>
> -----
> Gennadiy Greenberg
>
> chrisg wrote:
>
> > Is there any way to explictly specify that a table is held in memory?
> >
> > Thanks,
> >
> > Alister

Using the KEEP buffer pool is probably more appropriate from 8.0 onwards.

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Mon Mar 06 2000 - 04:01:18 CST