Source control shows differences even after check in

Track changes to Oracle schemas in your existing version control system.

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Source control shows differences even after check in

Postby rogertroller » Mon Feb 25, 2013 2:33 pm

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
 
Posts: 1
Joined: Mon Feb 25, 2013 2:27 pm

Postby Michael Christofides » Mon Feb 25, 2013 5:55 pm

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
 
Posts: 95
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby eportela » Sat Mar 09, 2013 2:00 am

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
eportela
 
Posts: 1
Joined: Thu Mar 07, 2013 7:26 pm
Location: Brazil

Postby Michael Christofides » Tue Mar 19, 2013 1:54 pm

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
 
Posts: 95
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby errr3 » Wed Feb 12, 2014 7:27 am

Same problem with context indexes on xmltype columns http://www.red-gate.com/MessageBoard/vi ... hp?t=19768
errr3
 
Posts: 3
Joined: Wed Feb 12, 2014 7:21 am


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest