-
Update Global Indexes with Parallel Clause.
Hi all!
I came across in a manual about this.But still have some doubt regarding the clause Parallel 5 degree used with UPDATE GLOBAL INDEXES.
Could anybody explain the significance of it.
ALTER TABLE SALES
EXCHANGE PARTITION SALES_Q1_2000
TABLE SALES_2000
UPDATE GLOBAL INDEXES
PARALLEL(DEGREE 4);
What would be the state of Local as well as Global Indexes in terms of USABLE,UNUSABLE status:
a).Will the local indexes be in a usable state but global indexes in unusable state.
b).Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is maintained.
c)..Will the local indexes be in a usable state but global indexes in unusable state considering PARALLEL(DEGREE 4)
is not maintained.
Thanks & Regards,
Amit.
Oracle DBA (OCP) v8i,v9i
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
|