Source control shows differences even after check in

[rogertroller]

After having checked in all objects of a schema to the svn, source control still shows differences between the db and svn. Even if I check in the "changes" again - the "differences" are still there.

Affected object types:

2 tables and an index

The scripts shown when pointing to the objet are equal.

Example:

CREATE UNIQUE INDEX tvdlib.sys_c0017837 ON tvdlib.tvd_source_exports(object_types)
VISIBLE PARALLEL (DEGREE 1 INSTANCES 1);

The thing that all of the objects have in common is the "visible" keyword.

[Michael Christofides]

Hi Roger,

Are they external tables by any chance? If you could email us (oracle@red-gate.com) all three CREATE statements hopefully that will help us recreate/fix the issue.

Best regards,
Michael
Product Manager

[eportela]

Same problem. In my case, there are 10 objects, 4 of them are external tables.
I sent to oracle@red-gate.com a file (redgate.zip) containing:

- The create table statements (generetade via Data Pump) of these 10 objects to you try to recreate the issue.
- The "Before" and "After" statements showed by the tool

Thanks in advance

Best Regards,

Everton Portela
_________________
Everton Portela
Oracle Senior Developer

[Michael Christofides]

As an update to this post, if you would like to request that we support ORACLE_LOADER and ORACLE_DATAPUMP access drivers, please vote and comment here:
http://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/3759719-add-support-to-oracle-loader-and-oracle-datapump-a