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

59 results found

  1. 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)
    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)
    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”

  2. 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)
    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)
    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.

  3. 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)
    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)

    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.

  4. A forward slash should be in the scripts so they are runnable via commandline without an extra step.

    1 vote
    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)
    completed  ·  Neil Anderson responded

    This is complete in Schema Compare and Source Control for Oracle. Help→Check for Updates

  5. 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)
    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)
    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”.

  6. the SQL Server version supports views

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

    I’ve just done initial work for this which should find it’s way into the next release. Obviously comparing and then syncing views depends a lot on their definition.

    This will be enabled by an option for the project which is off by default.

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

  7. 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)
    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)
    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”

  8. 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)
    You have left! (?) (thinking…)
    completed  ·  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)
  9. 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)
    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)
    completed  ·  Neil Anderson responded

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

  10. 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)
    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)
    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.

  11. 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)
    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)
    completed  ·  Neil Anderson responded

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

  12. 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)
    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)
  13. 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)
    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)
    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).

  14. Add support to ORACLELOADER and ORACLEDATAPUMP access drivers to fix some bugs related to external tables (see http://www.red-gate.com/MessageBoard/viewtopic.php?t=16543)

    1 vote
    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. 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)
    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)
    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.

  16. We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.

    21 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 now use Ignore Rules to specify what tables to include/exclude in your comparison – https://documentation.red-gate.com/dco5/setting-up-the-comparison/using-ignore-rules.

    You also have the ability to specify what tables and WHERE clauses, if needed:
    - https://documentation.red-gate.com/dco5/setting-up-the-comparison/selecting-tables-to-compare
    and
    - https://documentation.red-gate.com/dco5/setting-up-the-comparison/filtering-the-comparison-with-a-where-clause

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

  17. 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)
    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)
    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.

  18. 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)
    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)
    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)

  19. Allow for saving of database versioning in a sub-folder of the subversion repository rather than just the root of the repository.

    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)
    completed  ·  Anonymous responded

    This should now be fixed in the beta released yesterday (21 Feb), please do let us know if there are still issues!

  20. 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)
    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)
  • Don't see your idea?