I think it's something like:
ALTER USER <schema_owner> DEFAULT TABLESPACE <default_index_tablespace>;
Probably not what the product designers had in mind but I think you should
get the desired behaviour
HTH
Russell
John Dunn wrote:
>
> >When I create a user is it possible to specify a default tablespace for
> >indexes that is different from the default tablespace for tables?. Or =
> can I
> >only specify a different tablespace for indexes when I create the =
> index?
> >
> >This is Oracle 9.2
> > =20
> >
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 16 2005 - 09:39:26 CDT
