Red Gate forums :: View topic - Bug when comparing Indexes that have Parallel enabled
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Bug when comparing Indexes that have Parallel enabled

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
gilcrest



Joined: 01 Dec 2013
Posts: 3
Location: Boston

PostPosted: Mon Dec 02, 2013 12:17 am    Post subject: Bug when comparing Indexes that have Parallel enabled Reply with quote

When Schema Compare for Oracle finds two indexes that don't match due to differences in Parallel, if you want to choose the index without parallel enabled, this is the DDL the script provides:

ALTER INDEX fake_index_name ;

It should be:

ALTER INDEX fake_index_name NOPARALLEL;

The NOPARALLEL clause is missing...

Thanks!
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Dec 03, 2013 2:59 pm    Post subject: Reply with quote

Thanks for your post.

I could be wrong, but I don't think there would be any need to script the NOPARALLEL query hint when creating the index. As far as I can see the NOPARALLEL query hint is used to override the existing PARALLEL settings. If the index is created with NOPARALLEL then it is effectively like creating an index without the PARALLEL setting.

If I create an index in SQL Developer using the NOPARALLEL hint, then when I script out the DDL using SQL Developer, it doesn't mention the NOPARALLEL setting. I have a feeling Oracle doesn't even store the fact that the index was created with NOPARALLEL and treats it the same as an index that doesn't specify PARALLEL.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
gilcrest



Joined: 01 Dec 2013
Posts: 3
Location: Boston

PostPosted: Tue Dec 03, 2013 8:09 pm    Post subject: Reply with quote

Thanks for the reply, Chris. So, the issue is actually when I want to remove parallel from a given instance. For example, I compare schema A to schema B - schema A has a Parallel of 4 for index named fake_index_name, schema B has no parallel setup for the same index. I want to make fake_index_name in schema A look exactly like schema B, meaning I need to drop the parallel from the index. In this case, the tool provides "ALTER INDEX fake_index_name ;" when it should provide "ALTER INDEX fake_index_name NOPARALLEL;"

Hope this makes sense?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Dec 04, 2013 10:55 am    Post subject: Reply with quote

I think I follow. If you don't specify NOPARALLEL then the index after the alter keeps the original PARALLEL setting.

I'll test that out and report a bug if that's the case.

Thanks for the clarification.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
gilcrest



Joined: 01 Dec 2013
Posts: 3
Location: Boston

PostPosted: Wed Dec 04, 2013 11:14 am    Post subject: Re: Reply with quote

Chris Auckland wrote:
I think I follow. If you don't specify NOPARALLEL then the index after the alter keeps the original PARALLEL setting.

I'll test that out and report a bug if that's the case.

Thanks for the clarification.


Actually - the alter statement given by the tool "ALTER INDEX fake_index_name ;" is simply not a valid DDL statement... you need the NOPARALLEL in there...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group