Hi John, Im afraid you cant have a default index tablespace, have to specify it on the create command if you want a different tablespace On 6/15/05, John Dunn <jdunn@xxxxxxxxx> 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? >=20 > This is Oracle 9.2 >=20 > John -- //www.freelists.org/webpage/oracle-l