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.

20 results found

  1. When will Schema Compare support Oracle 12c?

    Things like lack of support of JSON objects, default on null on columns statements, and table compression statements cause us to use script rather than moving through the tool. The tool works great for things that have full support and would love to be running everything through it.

    46 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  ·  Schema Compare  ·  Admin →
    completed  ·  Doerte responded

    Redgate tools for Oracle are now compatible with Oracle version 12c. Full 12c support for Schema Compare was released earlier this year.

  2. Allow partial compare of schemas based on naming convention

    We manage ERP systems with larg schemas (150.000 - 200.000 objects) where only a small proportion - the custom objects - should be under source control / schema compared.

    To enable a decent use of Schema Compare for these systems, we would need to be able to compare schemas partially based on naming convention. Multiple assignments per schema should be possible, e.g. we want to match all objects for schema ABC matching the naming convention EE% and FF%

    40 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…)
    5 comments  ·  Schema Compare  ·  Admin →

  3. Need the filter capability that SQL Compare currently has

    SQL Compare allows the user to use a customized filter to exclude specific objects, object types, or objects with a certain named pattern.

    This would be extremely useful in the Oracle tool as well.

    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…)
    5 comments  ·  Schema Compare  ·  Admin →

  4. Create or replace

    For procedures/packages etc. it would be great to be able to have a "script as CREATE OR REPLACE" option.

    We would use this to generate scripts that could be kept under source control in Mercurial, and applied to the (shared) dev database as needed.

    We could also then use the tool to compare whether the database is up to date with the latest changes in source control.

    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…)
    1 comment  ·  Schema Compare  ·  Admin →
    completed  ·  Richard Mitchell responded

    I’ve just put this into our latest code so that we always generate CREATE OR REPLACE where we can. Surprisingly all the integration tests passed so this should make it into the next release.

    I don’t think there are any huge issues with always using the CREATE OR REPLACE syntax.

    This is now in our latest release via “Check for Updates”

  5. Option to Ignore External Table Location

    When comparing an External Table from one environment to the next, a difference in LOCATION (or filename) that the table refers to triggers a difference. We use External Tables to read data into our warehouse and currently have to manually ignore or remove those location changes from scripts when the difference is discovered. Adding an option to "Ignore External Table Location" would be very convenient for us.

    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…)
    0 comments  ·  Schema Compare  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is now in code (yet to be tested) for the next release of the tool.

    This is now in our latest release via “Check for Updates”

  6. Support for Queue Tables

    Please add support or the ability to find Queue tables.

    12 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 →

  7. Include materialized views in the schema compare

    It seems materialized views are not included in the compare. Or am I missing something?

    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…)
    3 comments  ·  Schema Compare  ·  Admin →
    completed  ·  Neil Anderson responded

    Materialized Views and MVIEW Logs are now supported in v3.0.0.686. Available via Help→Check for Updates

  8. Rename column - instead of drop and create

    If a column is renamed, Schema Compare for Oracle sees this as a drop and create, so during the table rebuild data is preserved asides from the “new” column.

    Could you make this work similarly to SQL Compare and execute a rename instead?

    8 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…)
    5 comments  ·  Schema Compare  ·  Admin →
    completed  ·  Richard Mitchell responded

    I’ve done the work for column rename detection. This will be a default option in the next release of Schema Compare and Source Control for Oracle.

    It probably won’t be perfect but the option can be turned off if it causes problems.

  9. Objects included in the results - CommandLine

    Filter for object types in command line application (SCO.exe).

    There are several cases when to apply only changes for specific object types (i.e. package, procedure, function) instead of all differencies. Such as in GUI.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Richard Mitchell responded

    This can now be done via a filter file in the latest command line release. Although I appreciate that a separate filter file isn’t ideal.

    These filter files are generated by Source Control for Oracle as object filters although they are a simple xml format if you want to generate them yourself.

  10. Allow limiting the deployment to only differences and objects missing , without project , at command line

    I must prevent to drop any tables, because the database may contains other tables for another application.
    And yes , they are in same schema.

    I need to deploy database changes on multiple databases, at client site, from a single snapshot.

    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…)
    0 comments  ·  Schema Compare  ·  Admin →
    completed  ·  Richard Mitchell responded

    In the upcoming release drop table and drop column are both classed as high-level warning events which can easily be stopped. The command line tools as an option to not deploy if there are medium or high level warnings.

  11. Support Table Type Columns

    It appears that Schema Compare does not support table types as columns. I have a table that had a type type added to it on dev. I compared it with QA and it correctly detected the difference, however, the migration script did not include the storage clause necessary for deployment. The statement it created is this:

    ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab);

    It should have created something along these lines:

    ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab)
    NESTED TABLE "AUDITVALUE" STORE AS "AUDITVALUES"
    (PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255…

    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 →
    completed  ·  Richard Mitchell responded

    I’ve been working on this lately as although it could create a new table the migration scripts were very broken.

    Let me know if you want a pre-release version to try the fix out.

    This will included in the next release of the tools.

  12. Please add possibility to compare and copy table and column comments

    We work a lot with table and columns comments, so they are mandatory. It would be nice to be able to compare the comments as well and be able to copy them.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Neil Anderson responded

    this has been included in Schema Compare 3.0.0.542 and Source Control 1.0.0.707

  13. The tool ignored the DDL differences between a partitioned table and a regular one! how is it possible? it is basic !

    differences between a partitioned table and a regular one! how is it possible? it is basic !

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Anonymous responded

    Hi Oshrat,
    By default Schema Compare has an option on to “ignore storage” as many customers are comparing environments that have different storage options. You can however turn this off in the options tab before comparing.
    Do let us know if it’s that option that is in fact not working properly for you, but otherwise I’ll mark this as completed in a few days.
    Cheers,
    Michael

  14. dotNet version

    System requirements for Schema Compare tell us about "Microsoft .NET Framework version 2.0 or later." Actually, the last version requires .NET version 4. The previous build required version 3.5 exactly. Such mess in versions frustrated me.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Anonymous responded

    Many thanks for reporting this Sergey, we have now updated that page. We are using some features in .NET 4 for the latest version, apologies for the frustration, we won’t be updating again for a long time now.

  15. Source Control Option - Generate object scripts in schema sub-folders

    Source Control Option

    When comparing multiple schemas all objects of same type go into one folder (e.g. all tables from all schemas into tables folder). In Oracle you normally look at objects by schema then type rather than this other way round.

    Please provide option (and set as default) to export into schema sub-folders then object type folders

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Brian Tufnell responded

    This is now implemented in version 3.0.0.196 which you can get via the Help menu in the tool (Help→Check for Updates).

    In this version multiple schemas are written to multiple sub-folders by default (the user just selects the parent folder) – we’ll look at adding a user-defined option to override this behaviour in a future release.

  16. Bug in compare with virtual column

    When I do a schema compare that has added a virtual column the alter table command that it generates has a bug in it.
    The statement it generates is:
    ALTER TABLE vendorportaluser.vendorcontacts ADD (dbupperusername VARCHAR2(30 BYTE) GENERATED ALWAYS AS (UPPER("DBUSER_NAME")));

    Which results in error:
    ORA-54015: Duplicate column expression was specified

    The correct syntax is:
    alter table VENDORPORTALUSER.VENDORCONTACTS add dbupperusername as (UPPER(DBUSER_NAME));

    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…)
    completed  ·  0 comments  ·  Schema Compare  ·  Admin →

  17. TNSNames list sorted?

    On New Project list, can the TNSNames list (to connect to the db) be sorted alphabetically? Just makes it easier to browse.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Aaron Law responded

    Update: v3 of Schema Compare has been released which includes this feature.

    Thank you for the suggestion! I’ve implemented this change for you on our early access branch and it will be included in the full product once the EA is complete. In the meantime you can get the EA from:
    http://downloads.red-gate.com/EAP/SchemaCompareforOracleBeta/SchemaCompareforOracleBeta.exe
    (this will install alongside any version you currently have installed if you want to give it a go)

  18. Help Contents - 404 Error

    I'm getting a "404: Page not found" when clicking on the "Help Contents" in version 3.0.0.219.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Brian Tufnell responded

    Hi Curtis

    Thanks for reporting this. As Neil mentioned previously, a redirect link on our website was broken.

    I’m pleased to say it’s now been fixed, so when you click “Help→Contents” it will take you straight to the V3 help page.

    Cheers,

    — Brian

  19. List Schema's Alphabetically

    Please sort the list of schema's alphabetically. Things show up in kind of a strange order right 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…)
    0 comments  ·  Schema Compare  ·  Admin →
    completed  ·  Brian Tufnell responded

    Hi Bjorn – many thanks for your feedback. We had noticed this, and a similar issue with the ordering of TNS names, in our own testing recently. Both issues are fixed in Schema Compare for Oracle V3 which we’re expecting to release commercially in a couple of weeks. The major new functionality in this version is the ability to compare and deploy your schema to a scripts folder, which you can then put under source control. If you’d like to try V3 before then, you can download it by signing up to the Source Control for Oracle beta program on the Red Gate website.

  20. Problem with schema compare 3

    With large Oracle schemas it appears to hang at 44% with idle connections to the databases it is comparing.

    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  ·  Schema Compare  ·  Admin →
    completed  ·  Brian Tufnell responded

    Hi Curtis

    We think this should be fixed in the latest version of Schema Compare for Oracle which you can get by using the “Help→Check for updates” menu option in the tool.

    If you could please try your comparison again with this new version, and let us know how it goes.

    Cheers,

    — Brian

  • Don't see your idea?