Source Control for Oracle 2.0.5.742

richardjm

Features

• Object filtering to limit objects placed into source control
• Credential failure against database or source control can now be fixed via "edit credentials"
• Search box would dissappear during refresh in lockables list
• Initial commit check-in comment

Fixes

• When refreshing with text in search box the program could crash

Schema Compare engine

• Allow ; on end of CREATE SEQUENCE statement
• More parsing of 12c object privileges (USE, FLASHBACK ARCHIVE, KEEP SEQUENCE, INHERIT PRIVILEGES, TRANSLATE SQL)
• Ignore tables and sequences created for spatial indexes
• User object privilege with option "exclude schema names" caused issues
• Materialized views ending with a single line comment "--" would produce invalid SQL when scripted
• "with read only", "with check option" case sensitivity fix
• PARALLEL support for materialized views

Release notes history

armplinker

I am not sure the PARALLEL support is working right. I just raised an error with an MV using the PARALLEL option. Reported through the tool

Also, shouldn't this post be in the announcements section? Just wondering...

richardjm

I've just had a look at this. I think according to the oracle documentation that PARALLEL should come before the REFRESH clause -

http://docs.oracle.com/cd/E11882_01/ser ... m#i2145767

This is what we assume and the script that we generate in the tool looks like, so I can only assume that this mview script was generated by hand. I've just run the mview through our parser moving the PARALLEL line and it seemed to prefer that.

Generally we only guarantee to parse scripts produced with the tool although we do try our best to support other scripts.