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

38 results found

  1. When you put a and interactive-html-report and its images folder underneath htdoc of an http-server, the images fail to show in Firefox while working fine in Internet-Explorer. This can be fixed easily by changing function SetupImagesDir() :
    instead of the currently generated backslash:
    imagesdir = reportFileName + "images\";
    use forward slash:
    imagesdir = reportFileName + "
    images\/";

    In my tests this works in both IE and FF both via direct file and http-server.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We are hoping to soon update the report entirely to be more consistent with the report generated by SQL Compare, the SQL Server sister tool. Please let us know if you have any other suggestions on what the report should show.

  2. I have many different objects in my schemas, but i need to syncronize only objects created within last hours or day. It would be very nice to optionally filter object after a creatino date (or the objects that have creaing date).

    I will put a new suggestion about a complete custopm filter (a string edited by user that is added to the where clause of SOCO)

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. When using the interactive html report currently a new folder for each new report is generated containing the exact same images. There should just be a general images folder by all reports. Alternatively there should also be an option to use images from redgate website remotely. This would make it easier to send out differences reports as e-mail.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  4. When generating a schema compare report there is the option to "Also include identical objects". When you choose that you get again ALL object types of identical objects. I want to be able to include only the identical objects of the filtered object type, which is possible for differing objects via choosing "Objects selected for deploment". I think objects excluded by filter should also be excluded in the report, no matter what.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  5. In 99% of cases i need NOT to deploy affected objects. I do small, incremental deploys.

    So i need an option so that SOCO, at deploy, will uncheck be default the checkbox "Deploy all affected objects" and to uncheck all the items in the affacted items list.

    There are cases when, if I forget to uncheck "Deploy all affected objects."and to uncheck "objects affected" I will put some productions down.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  6. The triggers in my database show that the schema is there when looking at the create sql via sql developer.
    I have checked to ignore schema's in object comparison.
    The source control for oracle sql does not have the schema in it.
    Consequently the tool shows all triggers that have the schema as changes.

    Shouldn't these be avoided due to checking of schema in edit comparison options...?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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.

  13. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. We are using Virtual Private Database on some schemas. These profiles are not included in current comparison.

    Please include this. :-)

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. When your source or destination is an SVN repository allow to select a specific revision of the repository.

    It is true that there are workarounds for this but it would save time to do it automatically in the tool because now either you have to checkout or update to an specific revision from the svn or you have to create tags in your repository for each version.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Create snapshot options should be similar to those in the SQL Server tool. We are currently limited to snapshot only from TNS and manual connection. We should have the options to create a snapshot from script file or source control. This is vital to our build automation

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    You can do this once you have performed a comparison the UI. I presume you mean using the “Create snapshot” in the start menu.

  17. I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. as SQL Schema compare sdk

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
2 Next →
  • Don't see your idea?