Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: Oracle, create Tables in Main-Memory, not on disk
Hi,
Try PL/SQL TABLE datatype
AMARENDRA Brett Neumeier wrote:
> Carsten Wiemann (carsten.wiemann_at_technet.net) wrote:
> : Is there a a function to create a table in the main memory, without
> : using the disk. I have a bottleneck( I think so) in the disks, and I
> : want to create a table (temporary) in the memory, [..]
>
> Well, you could create a RAM disk, create a tablespace on the RAM
> disk, create the table in that tablespace...
>
> That's the only way to create an actual *table* without using a
> disk at all. A previous suggestion about simply caching the
> table is probably a better idea, though.
>
> --
> -bn
> random_at_interaccess.com (PGP 2.6.2 public key available on request)
> "There is no .signature -- only ZUUL!"
-- ***************************************************************** AMARENDRA B NETTEM Oracle Certified DBA (OCP) Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Residence: ----------- 5039 N E River Road, Apt. 1A NORRIDGE, IL 60656 Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Fri Feb 20 1998 - 00:00:00 CST