Red Gate forums :: View topic - Source control shows differences even after check in
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Source control shows differences even after check in

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
rogertroller



Joined: 25 Feb 2013
Posts: 1

PostPosted: Mon Feb 25, 2013 2:33 pm    Post subject: Source control shows differences even after check in Reply with quote

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.
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 90
Location: Red Gate Software

PostPosted: Mon Feb 25, 2013 5:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
eportela



Joined: 07 Mar 2013
Posts: 1
Location: Brazil

PostPosted: Sat Mar 09, 2013 2:00 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
Michael Christofides



Joined: 20 Apr 2011
Posts: 90
Location: Red Gate Software

PostPosted: Tue Mar 19, 2013 1:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
errr3



Joined: 12 Feb 2014
Posts: 3

PostPosted: Wed Feb 12, 2014 7:27 am    Post subject: Reply with quote

Same problem with context indexes on xmltype columns http://www.red-gate.com/MessageBoard/viewtopic.php?t=19768
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group