Re: Memory Resident Tables.

From: Thiru <tmgn_at_excite.com>
Date: Thu, 16 Sep 1999 11:02:55 -0400
Message-ID: <37E1069F.75C4CEB5@excite.com>

Are U talking about Cached Tables ? If yes,
>Alter Table <Table_name> Cache ;

will put the table into the buffer Cache and retain it ..However exercise caution in Caching tables..They are generally recommended for Frequently used Small tables(Lookup tables)..

-Thiru

amir7860_at_my-deja.com wrote:

> Can I create memory resident tables and give select grant to selected
> users using Oracle 8i?
>
> If yes then how?
>
> Thanx in advance for any input.
>
> Amir
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 16 1999 - 10:02:55 CDT