How to have a 'default tablespace' for indexes?
mtefftSep 26 2012 — edited Sep 26 2012For 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