-
INSERT /*+ PARALLEL (storm_track97, 4) */ INTO storm_track97
SELECT /*+ PARALLEL (storm_track, 6) */ *
FROM storm_track
WHERE current_time < '01-JAN-98';
If a global index exists on the CURRENT_TIME column of the STORM_TRACK97 table, what will happen when this command is issued?
I know the result, it will fail because of Global Index but I don't know much about global index so Where can I find the information?
Also, which data dictionary will tell me the degree of parallelism?
Thanks.
-
V$PQSESSTAT
V$PQSLAVE
V$PQSYSSTAT
V$PQTQSTAT
Why would it fail for global index, it is same as normall index.
thanks
GP
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
|