Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

default index tablespace for a user

Pavan DBAMar 9 2009 — edited Mar 11 2009

Hi Friends,

We know that we can assign default tablespace and temporary tablespace (if 10g then temp tablespace group) to a user while creating. I wann to know whether there is any option provided to specify default index tablespace in 9i,10g or 11g?

Database: 9.2.0.6
OS: IBM AIX 5.2

my problem is, users are creating indexes in their default tablespace even though quota on index tablespace is provided. so now i want them to forcely create indexes in index tablespace only.

thanks in advance.

This post has been answered by Richard Foote on Mar 11 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2009

Added on Mar 9 2009

#general-database-discussions

12 comments

1,242 views