Activity overview
Latest activity by gilcrest
Option to turn off pre-compiling of dependent objects
Hi! At my shop, we primarily use PL/SQL's OO abilities, and as such have a LOT of object types defined. We love the tool, however, for any object that has changes, any dependent objects are also ...
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... / comments
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 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? / comments
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 n...
Bug when comparing Indexes that have Parallel enabled
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:
ALTE...