Re: INDEX Use How?

From: Roger Snowden <rsnowden_at_supergeek.com>
Date: 1998/02/06
Message-ID: <01bd3350$01816760$096fc589@WS1009.labinterlink.com>#1/1

You aren't going to be able to guarantee the index segment location default. You only get one default tablespace location (besides temp, of course). You might be able to fix up some nifty scripting tool for your users that provides a storage clause for them.

Roger

byrd_at_mscf.med.upenn.edu wrote in article <886612885.1590755333_at_dejanews.com>...
> We want to establish two tablespaces(one for tables and the other for
> indices). If we give users privileges to create an index via "create
> index" or create a table using a primary key, how can we guarantee that
> the indices reside in the established index tablespace by default? In
> other words how do we make sure all indices are where we want them to be.
>
> Karen Byrd
> Univ of Pa, School of Med.
> Computing and Info Tech
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Fri Feb 06 1998 - 00:00:00 CST