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.

59 results found

  1. Source Control for Oracle v2.0.1.173 does not support default value oin INTERVAL column type

    Source Control for Oracle v2.0.1.173 does not support default value on INTERVAL column type

    This table column definition throws an error when Source Control for Oracle looks for changes..

    ...
    "SUSPEND_DAYS" INTERVAL DAY (3) TO SECOND (3) DEFAULT INTERVAL '5' DAY NOT NULL ENABLE,
    ...

    ); ---> RedGate.Shared.Utils.InvalidStateException: Parsing failed with message SyntaxError. Unexpected token ''5'' (Line 29, Col 62) symbol Id.

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

    This is believed to be fixed in the upcoming release, hopefully in the next couple of days once we’ve finished release testing.

  2. Configure timeout settings on command line interface.

    Currently there is a 60 second timeout on all script executions for SCO deployment. I have run into situations where indexes on large data sets or table rebuilds on large tables exceeds that time frame resulting in SCO prematurely exiting the script deployment. The recommendation was to invest in better hardware. Unfortunately, better hardware cannot solve this problem where large data sets are in play. Having the ability to adjust the timeout default could help avoid such situations.

    See for reference issue: http://redgatesupport.red-gate.com/requests/16832

    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…)
    4 comments  ·  Admin →

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

  4. Command line feedback

    Errorlevel is not updated by DCO32.exe if there are différences in data of two schémas.

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

    In the next release SDC should return 61 if there were differences or 62 if there were differences and the synchornization failed.

    This hasn’t been thoroughly tested to any issues please let support@red-gate.com know.

    By the way I can see you commenting on your own idea :)

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

  6. Support an LDAP connection, so the server name is not required

    Support an LDAP connection, so the server name is not required. We would like to use a server alias only, so that all developers don't have to know or update the server name locally.

    10 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  ·  All Oracle  ·  Admin →
    completed  ·  Richard Mitchell responded

    I’ve got a working prototype that allow connections via LDAP. You will need to have the oracle client installed and in the TNS Connection – Network Alias field enter the ldap server alias.

    I have now extended this to allow “OS Authentication” which seems to work on my very simple AD implementation.

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

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

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

  9. Implement (manually) sorting of projects in Source Control

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    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.

  10. Options for underlying scripts

    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)
    Close
    Close
    You have left! (?) (thinking…)
    11 comments  ·  Source Control  ·  Admin →
    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”.

  11. UI Improvements

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    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.

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

  13. Package generation

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  Neil Anderson responded

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

  14. Filter objects added to source control

    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)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Source Control  ·  Admin →
    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).

  15. 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.

  16. Source control for GIT

    179 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…)
    20 comments  ·  Source Control  ·  Admin →
    completed  ·  Richard Mitchell responded

    This is now available in the final v3 release of Source Control for Oracle – available now

  17. Version public synonyms whose referenced objects are in my project

    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)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Admin →

  18. Data should be a part of the version control for metatables

    Some tables are metatables involving data/information connected to the software releases. The Source Control utility should have a possibility of setting a switch on the tables, turning data compare on. This way you could include data for these tables in the version control.

    131 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…)
    14 comments  ·  Source Control  ·  Admin →
    completed  ·  Doerte responded

    We just released static data support for Source Control for Oracle.

  19. Specify tables to compare up front

    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)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Data Compare  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    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!

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