How can we improve our Oracle tools?

Filter objects added to source control

In our schema(s) there is a mixture of third party code that we don't touch, and our own code where we'll amend and add objects. Please add a way to filter out the third party objects.

(If you vote on this, please let us know if the objects concerned are named in a particular way that would make filtering easier)

39 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Michael ChristofidesAdminMichael Christofides (Product Manager, Red Gate) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Claudio RossnerClaudio Rossner shared a merged idea: Filter  ·   · 
    T Mohan ReddyT Mohan Reddy shared a merged idea: Filter to exclude certain type of Obects to List and check in  ·   · 

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        We have Oracle Ebusiness Suite. We have a few hundred custom objects which we need to source control but due to Oracles Ebusiness security limitations they have to reside in the Oracle Apps schema. This schema has so many objects (30,000+) that Red Gate Source Control cannot even load the entire list of objects.

        We need to be able to pre-filter by object name so that Red Gate will only try to list and source control objects that meet the filter criteria (IC_%).

        We use other tools...TOAD and SQL Developer that have this capability, so it seems like it should be possible.

      • AntonioAntonio commented  ·   ·  Flag as inappropriate

        Hello,
        I think this is a great feature. Currently I am testing this application in our environment and we have several tables that we do not need to have under control version. It would be nice if there is an option to filter what you want to include (or exclude) from the versioning.

        In our case, the objects are usually named with an specific prefix or suffix. Allowing filtering as in SQL with the "like" operator could be enough.

      • Michael WaybrightMichael Waybright commented  ·   ·  Flag as inappropriate

        If a defect is identified and has priority to be deployed to the next environment then filtering any ongoing effort to provide the deployment branch for the unplanned defect has value.

      • Tim PurvisTim Purvis commented  ·   ·  Flag as inappropriate

        This would be useful for filtering out SYSNT tables. Is there ever a case where these should be included in the repository?

      • Michael ChristofidesAdminMichael Christofides (Product Manager, Red Gate) commented  ·   ·  Flag as inappropriate

        Hi Claudio,

        Thanks for your request, we're researching this at the moment. It would really help if you could be more specific about why you'd like this and what you're hoping to achieve.

        Are you simply trying to make life easier on the Check In tab? Or perhaps trying to exclude certain objects from ever making it into source control?

        If it's the latter, I'll merge this idea with the following:
        http://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/3784708-filter-objects-added-to-source-control

        Many thanks,
        Michael

      Feedback and Knowledge Base