Re: Specifying default tablespaces for indexes
- From: <rjsearle@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 16 Jun 2005 23:34:17 +1000
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
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
