Oracle tools

Welcome to the Oracle tools feature suggestion list. Find out more information about our current tools here: http://www.red-gate.com/oracle

If you have any questions, need help or have found a bug, please visit the forums at: http://www.red-gate.com/messageboard/index.php?c=19

How can we improve our Oracle tools?

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.

  1. Multi-Select for conflict resolution

    Ability to tick multiple items and resolve when faced with lots of conflicts

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  2. Synonym Handling w/ "Exclude Schema Names" option Enabled

    With the “Exclude Schema Names” option enabled, SCO identifies false-positive mismatches for public synonyms.

    In Oracle public synonym DDL w/o owner specified defaults the object owner to current user.

    CREATE PUBLIC SYNONYM foo_bar FOR bar
    /

    SELECT *
    FROM all_synonyms
    WHERE synonym_name = 'FOO_BAR'
    /

    SCO happily generates the Public synonym DDL w/o the owner specified (and it can be executed as such). However, on subsequent comparisons the underlying object’s qualified name is used and the public synonyms are all identified as being different.
    e.g. CREATE OR REPLACE PUBLIC SYNONYM foo_bar FOR my_schema.bar vs. CREATE OR REPLACE PUBLIC SYNONYM foo_bar…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  3. check-in comment/message as mandatory field for commits to a repository

    Please provide an option for Source Control to make the check-in comment a mandatory field for all commits to a repository. Commits/check-ins without comment should be rejected. With the current Version of Source Control (5.3.1.2355) it is possible to commit changes without a comment to a git repository in Azure DevOps - even though a local git repository doesn't allow to commit without a message.

    23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  4. GIT should not download the entire repository

    When I look at RedGates local files, it has downloaded my whole solution. Shouldn't it just be getting the files in the database folder I specified? For bigger projects this takes a long time.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  5. Synonym Ignore bug

    When entering ignore mask into PublicSynonym section, the ignore does not work - all public synonyms are still compared. But if the same ignore mask is entered into Synonym section, public synonyms are affected.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  6. wildcard

    Please add advanced filtering in Schema Compare. E.g. wildcard or regex matches to only show objects matching a certain criteria.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  7. Modify Oracle Data Compare to display table name when /verbose option is used on the command line

    The current command line option runs but produces no output until the entire compare is completed, the GUI tells you what table it is on and the % complete. The batch process should be able to do the same.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  8. Extend SQL parser to read scripts generated by other tools

    If the SQL parser could read DDL generated by other tools (e.g. data modeling tools), then the schema comparison could find differences between the schema as defined by those tools versus a database.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Exclude system-generated interval partitions from comparison and DDL

    For background on Oracle's interval partitioning feature, see chapter 4 of Oracle Database Concept for release 12.2.

    Our practice is to create interval-partitioned tables with the minimum number of partitions necessary to create the table (usually just one partition), and let Oracle create all others as data arrives requiring them. Between test, QA, and production databases, data arrives at different times, giving rise to automatic creation of different partitions. But because these differences are only a side-effect of different contents, they are not relevant, in the same way that differences in system-generated constraint names are not relevant. Changing the partition…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  10. Pre-script introduction in the scheme compare deployment script.

    Hi , I am trying to understand how to introduce a pre-script ALTER SESSION SET CURRENT_SCHEMA = <> SQL statement in the top of the deployment script which is generated during the schema compare either between source DB vs target DB or TFS vs Target DB.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  All Oracle tools  ·  Flag idea as inappropriate…  ·  Admin →
  11. DB or Version Control URL update functionality

    There is no functionality to update an existing project GIT repository or DB URL.

    I have to update it under :

    ConnectionStore.xml and LinkedDatabase.xml

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  12. Automap Source Control schemas with existing SchemaInformation.xml files

    If the schema has already been extracted by Schema Compare for Oracle, Source Control should use the existing SchemaInformation.xml files to auto-map folders to schemas.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  13. scripts break out

    The scripts can become quite large when comparing tables. Need a way to make the scrips smaller - multiple outputs for same table - in order to have a script that is runnable in sql. For example - when comparing a table that generates 50K records the output script is not editable by most editors - need to break it out in multiple files.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  14. Your Oracle connection via Wallet authentication doesn't appear to work properly.

    It's less an idea than a complaint. I'm a seasoned DBA working with a large number of developers. Developers do not have elevated privilege access to our QA or production environments. I'm wanting to set up a wallet so this tool can access those environments without requiring login/password information. I've setup sqlnet.ora and ldap.ora (we don't use tnsnames.ora) and can connect via the wallet entry using SQL*Plus on my local machine without issue. However, your product (Schema Compare) fires off an ORA-01017 (invalid login/password). Yet when I use normal credentialed login procedures via Schema Compare, the test works just fine.…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  All Oracle tools  ·  Flag idea as inappropriate…  ·  Admin →
  15. separate type spec and type body

    Please separate type specifications and type bodies. (e.g. "CREATE TYPE FOO AS OBJECT" and "CREATE OR REPLACE TYPE BODY FOO"). Most of the time our changes are only to the body but Schema Compare will try to recreate the spec on deployment even if the spec has not changed.

    This will fail if it has dependencies and make automated builds fail when using the Deployment Suite for Oracle with a build system.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  16. Sorting Database Objects in Sync script

    When we create a syncronization script we have diffrent order of objects from time to time. It is not very good for us, because it is hard to find out changes.
    Could you please make that the order does not change (for example in alphabetical order).

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  17. BUG!!!!

    This has been an issue with Oracle tools for some time.

    A table with a Generated column has a bug which inserts an extra right parentheses in its definition. Can be seen in Source Control as well as Schema Compare.

    ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1)) NOT NULL,

    tool generates:

    ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1))) NOT NULL,

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  All Oracle tools  ·  Flag idea as inappropriate…  ·  Admin →
  18. Integrate the Oracle Tools with Oracle SQL Developer

    Looking for feedback from our Oracle Users if they would like integration with Oracle SQL Developer.

    Launch the tools from within the IDE.
    Or Perform Source Control for Oracle Check-in or Get Latest process from within the IDE.

    Please comment or vote on this topic.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Repository Change History is not Respected

    On git when new Features are merged into Develop Branch , Source Control take Database Schema as Good and not the new changes on Develop. If like don't considerate last DDL TIme of an object to diff between new and old.

    One example are Hot Fix merged on Develop branch, when a horfix was resolved and you are going to integrate changes in Develop Database, Source Control consider Develop Database as Good schema and not the new Hot Fix Change merged into Develop Branch. Generating Check In changes and not Get In Updates.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  20. Source Control feature for Mercurial Kiln

    Please add an option to directly integrate Source Control with the Kiln Repository. We could see no option other than GIT, Team, SVN etc.,

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

Oracle tools

Feedback and Knowledge Base