Hi
I am using an ETL process to load an Oracle 10g D/B.
These processes are largely immutable and have SQL code generators to enable / disable constraints.

Note that the process does not allow one to drop and recreate the constraints.
Nor does it allow to customize the code generator to use a specific index while enabling constraint.

With this background, is there any way to specify the tablespace in which the primary key index is to be rebuilt *WHILE RE-ENABLING THE CONSTRAINT*

Note: there is no other option other than to disable / enable the constraint.

Since the default tablespace is different from the tablespace in which the objects reside, the index is being rebuilt in a diff tablespace which violates one of the requirements of our system. The default tablespace cannot be changed