RE: HOW TO CACHE THE TABLE??

2001-05-03 Thread Mark Leith 



alter 
table table_name cache;
 
HTH
 
Mark

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin 
  K.KaradenizSent: Thursday, May 03, 2001 03:31To: 
  Multiple recipients of list ORACLE-LSubject: HOW TO CACHE THE 
  TABLE??
   I wonder how can I cache a table other than 
  creating it with the cache option.??
   
  Bunyamin K.Karadeniz    
  Database Group / Information Systems Department     
  HAVELSAN Ankara /TURKEY    Tel : +903122873565 / 
  1681    Mobile Tel : +90 535 3357729
   
   

RE: HOW TO CACHE THE TABLE??

2001-05-03 Thread Tirumala, Surendra 

Use 
alter table  cache;
 
HTH,
Suren

-Original Message-
Sent: Thursday, May 03, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L


 I wonder how can I cache a table other than creating it with the cache
option.??
 
Bunyamin K.Karadeniz
Database Group / Information Systems Department 
HAVELSAN Ankara /TURKEY
Tel : +903122873565 / 1681
Mobile Tel : +90 535 3357729
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tirumala, Surendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).