How can we help you today? How can we help you today?

Source control shows differences even after check in

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.
rogertroller
0

Comments

4 comments

Sort by
  • 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
    Michael Christofides
    0
  • 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
    eportela
    0
  • 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
    Michael Christofides
    0
  • errr3
    Same problem with context indexes on xmltype columns http://www.red-gate.com/MessageBoard/vi ... hp?t=19768
    errr3
    0

Add comment

Please sign in to leave a comment.