-
specifying index tablespace while enabling disabling primary key constraints
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|