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.

129 results found

  1. Add private DB links

    Add DB links owned by the schema in the snapshot creation / compare options.

    6 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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. Add support for Git Push and Pull requests

    Add the ability to perform push and pull requests through the Source Control for Oracle GUI

    23 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    under review  ·  AdminStephanie (Product Manager, Redgate) responded

    In our new migrations-based solution, Redgate Change Control, we treat Git as a Distributed Version Control system with Push and Pull capabilities.

    We are working towards merging these tools into 1 tool to meet all your database versioning needs. At that point, we should be able to provide push and pull for Git for state-based projects.

    For more information about version control in Redgate Change Control, see https://documentation.red-gate.com/dso/redgate-change-control/version-control.

    Please let me know if you have any questions. Thank you!

  3. Migration script for Oracle tool

    Allow to create a migration script from Oracle tool. (exists some alternative solution now?)

    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  ·  All Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Integration with TFS2015

    7 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Please add ssuport for oracle CONTEXT object

    The Oracle CONTEXT object is not seen by Source Control.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Source control for oracle polling interval should be configurable in UI while creating project

    Source control for oracle polling interval should be configurable in UI like minutely/hourly/daily/weekly. This will help us reduce the burden in environments like test/uat/prod, where we don't this to become a performance issue.

    14 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Reporting Feature in Data Compare for Oracle

    Please add further granularity to the number of rows to include when generating a HTML report. Currently the user can choose to "Only include first 1000 rows" or including all rows.

    Please add further options to select:
    Only include first 10 rows.
    Only include first 1000 rows.
    Only include 'x' number of rows.

    4 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. hide

    Add option to filter out object that EQUAL.
    In other words - show only differences/all/etc.

    Add ability to go Next Difference (when usig show all)

    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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Be able to launch Schema Compare for Oracle from within Windows Explorer by clicking on the .ocp project file?

    Received a support request from a customer looking to start or launch a comparison by simply clicking on the project .ocp file.

    Many Thanks
    Eddie Davis

    Redgate Software Ltd
    Technical Support Engineer

    6 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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Spilt the 'Ignore Constraint names' option into 5 separate options.

    The following suggestion is from a customer I performed a remote desktop session with.

    Current in Schema Compare there is a single option to ‘Ignore constraint names’ when comparing objects. The constraints are still deployed. The option covers Primary Key, Foreign Key, Check, Default and Unique constraints.

    Could this option be spilt up and replaced by the following 5 options:

    • Ignore Foreign Constraints when comparing and deploying.
    • Ignore Check Constraints when comparing and deploying.
    • Ignore Default Constraints when comparing and deploying.
    • Ignore Unique Constraints when comparing and deploying.
    • Ignore Primary Key Constraints when comparing and…

    7 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. New option is needed to compare mviews as just tables (ignore mview definition)

    Due to DML-only replication requirements target schema might contain only tables for related mview in source schema. In this case current configuration of SC shows difference: mview exist only on source and tables exist only on target. This is not correct if compare tables only.

    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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. When changing a table to a view Schema Compare does not drop table first, and then create view.

    Could it interpret the order to take same-named objects?

    4 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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Severity: High Object: <schema>.<table> Title: UnsupportedDatatypeConversion Deployment cannot convert a DATE datatype to a TIMESTAMP(3)

    This can be accomplished with an alter statement. Why isn't the tool doing that?

    Thanks,
    Mike

    4 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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    planned  ·  Richard Mitchell responded

    Sounds like this is a bug which is best raised via support@red-gate.com

    From what I can see DATE is equivalent to a TIMESTAMP without any timezone information. Looks like it isn’t one of our automatic conversions currently so we can add some test cases and make it happen.

  14. Ability to select same schema as source and target specify scn or flashback time of both

    Oracle has a feature called flashback query/schema that allows you to view a table/schema as of a particular timestamp. For some projects, there is a need to identify all the tables inserted/updated/deleted by a particular application process.

    This would be an additional use case for Data Compare if it checked if flashback was enabled on the source and target schemas and allowed specifying a time.

    Then it could be used for my use case - i.e. identifying what impact a particular front end screen or batch process had on the database.

    It could also be used after a major incident…

    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  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Support jobs

    The tool does not support object type : JOBS .
    The job belongs to the selected schema and the " schema compare / Source Control " ignores this type of object.

    45 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  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. Provide support for EZCONNECT Oracle connection strings

    Dialogs for connection strings should permit pasting an EZCONNECT string and just using it.

    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  ·  All Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. Include support for ignoring ignored items in subversion

    Include support for ignoring ignored items in subversion

    This is NOT the same as filtering out objects. Once an object is in the svn:ignore it is supposed to be dead to subversion until revived.

    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…)
    3 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. Schema Compare should be able to ignore system generated names for supplemental log groups

    Schema Compare should be able to ignore names for supplemental log groups. I have many differences on tables that I do not care about like this (the names were generated by GoldenGate):
    ALTER TABLE schemaname.tablename ADD SUPPLEMENTAL LOG GROUP ggs_84245 (columnname) ALWAYS;

    6 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…)
    under review  ·  3 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. Selecting TABLES list from Excel / Text file ?

    If the source schema has around 1000 tables and we want to compare only 500 tables. Its a very tedious job to select all the 500 tables manually in the TABLES options tab. If we have all the 500 tables list stored in an excel sheet,csv,txt format. It would be good if data compare tool GUI (or) command line utility has a way to read all the user defined tables list from the excel/txt/csv sheet.

    13 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  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  20. Export History of Changes from Source Control for Oracle

    4 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
1 2 4 6 7
  • Don't see your idea?