Skip to content

Oracle

Welcome to our Oracle solution feature suggestion site. Find out more information about our current offering at www.redgate.com/oracle.

If you have any questions, need help, or have found a bug, please visit the forums at forum.red-gate.com/categories/oracle-tools.

Oracle

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve our Oracle solution?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

26 results found

  1. Refreshing the schema compare on demand

    Source Control for Oracle - Please do not run the refresing automatically when the app is openned. Run on demand when user click Reresh.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →

  2. UserObjectPrivileges

    It is not generating the UserObjectPrivileges scripts correctly, it is using the folder name of the repository instead of the schema name we are versioning:

    Here is an example:

    GRANT EXECUTE ON "branches/devl/db/devl".function TO user;

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Source Control  ·  Admin →

  3. Option to Check Out/Lock

    When working on an object, we would like to see an option to check-out and/or lock the item it is mapped to in source control. Preferably, we would like this to happen when the item is edited and compiled. Again, this could be an XML config file option of some kind, or an option during check-in to lock the file for the user checking it in.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    This has been released in the latest versions of Source Control for Oracle. The upcoming release removes the clutter of locking partitons and lobs which can only be modified with the connecting table object.

  4. Tool should have search capability to look for a particular Object in that scehma

    As we have lot of objects in the schema, if we want to lok for a particular object we dont have search capability in the tool

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    The latest versions of the tools have a filter capability on the check-in page to search particular objects.

    (just doing a review of all uservoice requests)

  5. Add Versioning Support for Materialized Views and MV Logs

    It would be nice if Source Control for Oracle could support versioning materialized views and materialized view logs.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    completed  ·  Neil Anderson responded

    This has been complete in v1.0.0.755 of Source Control for Oracle, available via Help→Check for Updates

  6. TFS client not found

    I'm getting an error that TFS client not found. I don't see any documentation as to what the RedGate software is expecting to see as a "TFS client". Please advise.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    completed  ·  Anonymous responded

    An alternative to needing Visual Studio installed is to use Team Explorer or Team Explorer Everywhere

  7. The code comparison window should be resizable vertically.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    completed  ·  Anonymous responded

    Thanks Leigh, this should now be the case in the latest beta release

  8. Local git repository - a documented example

    Could you post somewhere an example of Source Control with a local git repo? I have done "git init --bare" but sitll get this:
    Git directory must be an existing bare repository, for example 'git init --bare'

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    We did have an issue that we fixed in the latest release to do with using a file uri rather than a path. But I don’t think this is your issue.

    So eg
    C:\>cd tempora

    C:\tempora>mkdir test

    C:\tempora>cd test

    C:\tempora\test>git init —bare
    Initialized empty Git repository in C:/tempora/test/

    Then link to “c:\tempora\test” in the first box and leave the second box empty or not and it works (for me anyway).

  9. Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle?

    Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle? Two tools behave like same and give same structure

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →

  10. The DATABASE listing on Source Control for Oracle just shows the host name and no instance

    REviewing the list of Source Control projects, the database name is just the IP address/host name. It should include the SID and/or SERVICE to be useful.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    Good point. As I’ve got two lines for information I’ve added that to the next release.

    I’ll also include the port number if it’s not 1521.

    To see full information if it’s truncated simply hover.

  11. NEXT /*1:Days*/ sysdate + 1 in Materlized View in Database not in Source Control SVC

    Bug, /1:Days/ in Database Version, not in SVC therfore always x number of mv objects to check in and when try to check in will not update matrialized views

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →

  12. Source Control for Oracle v2.0.1.173 does not support default value oin INTERVAL column type

    Source Control for Oracle v2.0.1.173 does not support default value on INTERVAL column type

    This table column definition throws an error when Source Control for Oracle looks for changes..

    ...
    "SUSPEND_DAYS" INTERVAL DAY (3) TO SECOND (3) DEFAULT INTERVAL '5' DAY NOT NULL ENABLE,
    ...

    ); ---> RedGate.Shared.Utils.InvalidStateException: Parsing failed with message SyntaxError. Unexpected token ''5'' (Line 29, Col 62) symbol Id.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is believed to be fixed in the upcoming release, hopefully in the next couple of days once we’ve finished release testing.

  13. Implement (manually) sorting of projects in Source Control

    Now the projects are listed in the order they were created. I would like to be able to sort them manually in a more logical order.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    In the upcoming release (this week hopefully) the projects are sorted by name on startup. Not quite the flexibility you were after but I hope this will satisfy you for now.

    What sorting at startup means is that renaming a project will not move it in the project order until the tool is restarted.

  14. Options for underlying scripts

    Allow us to specify options (like in Schema Compare for Oracle) when creating a Source Control for Oracle project (e.g. we'd like to include storage clauses in the table create scripts)

    Note from Red Gate: If you vote on this feature request, it would also be helpful to know what options specifically you'd like to see.

    47 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    11 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    Storage options are now available in the latest release of the tools.

    There are a number of new “Include ..” storage options available in both the Schema Compare and Source Control tools.

    To get to options in Source Control right click on the project in the start screen and selected “Edit comparison options”.

  15. UI Improvements

    Put a border around the application frame so it's eaier to detect on the screen with 20 other windows open...

    Much more importantly you need to add a way to cycle through the differences in the source control diff window by allowing to move through the changes instead of having to scroll. The blue is very hard to see in the side bar, too. Allowing simple text search wouldn't hurt either.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    There is a border around the application. There’s also a “Previous” and “Next” button at the top of the differences pane near the bottom. This will jump you the Previous/Next difference within the script respectively.

  16. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is now available via check for updates or to be downloaded from our website.

    This allows objects to be filtered based on type or substrings (both include and exclude).

  17. Source control for GIT

    179 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    20 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is now available in the final v3 release of Source Control for Oracle – available now

  18. Version public synonyms whose referenced objects are in my project

    Our application has public synonyms that should be versioned along with our application, but Source Control for Oracle isn’t picking up the public synonyms that point to objects in our versioned schemas.

    Would it be possible to look for public synonyms whose referenced object is in the list of schemas that are in the SC project? For example, if my project schemas were ‘MYSCHEMA1’ and ‘MYSCHEMA2’, then SC for Oracle would look to version any public synonyms with a query like this:

    SELECT *
    FROM allsynonyms
    WHERE owner = 'PUBLIC'
    AND table    owner IN ('MYSCHEMA1', 'MY…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Admin →

  19. Data should be a part of the version control for metatables

    Some tables are metatables involving data/information connected to the software releases. The Source Control utility should have a possibility of setting a switch on the tables, turning data compare on. This way you could include data for these tables in the version control.

    131 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    14 comments  ·  Source Control  ·  Admin →
    completed  ·  Doerte responded

    We just released static data support for Source Control for Oracle.

  20. Synonym support

    Generate a script that contains all the synonyms that have been created to support the schema being version controlled.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    I believe this is a request for public synonyms which has been implemented in the latest release.

    Please let me know if that’s incorrect.

← Previous 1
  • Don't see your idea?