Re: INDEX Use How?

Karen,
Unfortunatly you can not control the location of TWO default types of tablespaces. Of course you can set a default tablespace for a user, but thats about it.

You can set quotas on the tablespaces you don't want users writing to, but there really is no way system way to force indexes to go one place and tables another.

I'm sure you know that you control the placement of these objects via the create table/index statements....

Robert
byrd_at_mscf.med.upenn.edu writes:
>
> 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 Wed Feb 04 1998 - 00:00:00 CST