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 -> INDEX Use. How?

INDEX Use. How?

From: Karen Byrd <byrd_at_mscf.med.upenn.edu>
Date: 1998/02/04
Message-ID: <byrd-0402981215120001@mscfadm6.med.upenn.edu>#1/1

We want to establish two tablespaces(one for tables and the other for indices). If we give users the privileges to create an index via "creat index" or create tables using a primary key how can we guarantee where the indices are created by default? In other words we want all indices to reside in the tablespace we are going to set up for them every time.

TIA

-- 
Karen Byrd
Univ. of PA, School of Med.
Computing and Information Technology
byrd_at_mscf.med.upenn.edu 
Received on Wed Feb 04 1998 - 00:00:00 CST

Original text of this message

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