Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> INDEX Use. How?
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.eduReceived on Wed Feb 04 1998 - 00:00:00 CST
![]() |
![]() |