Skip to Main Content

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!

How to have a 'default tablespace' for indexes?

mtefftSep 26 2012 — edited Sep 26 2012
For a particular schema, we would like to have indexes placed in a different tablespace than the tables they support. Unfortunately, we do not have full control over the CREATE INDEX statements - most are created on the fly (by ODI=Oracle Data Integrator).

Is there any suggested technique for intercepting or overriding the tablespace used for an index, at the time it was created? I have been looking at DDL triggers but there does not seem to be a means to tweak the statement before it is executed.

Thanks,
Mike
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2012
Added on Sep 26 2012
13 comments
1,298 views