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

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/174 ... datapump-a

errr3

Same problem with context indexes on xmltype columns http://www.red-gate.com/MessageBoard/vi ... hp?t=19768