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. The DATABASE listing on Source Control for Oracle just shows the host name and no instance

    REviewing the list of Source Control projects, the database name is just the IP address/host name. It should include the SID and/or SERVICE to be useful.

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

    Good point. As I’ve got two lines for information I’ve added that to the next release.

    I’ll also include the port number if it’s not 1521.

    To see full information if it’s truncated simply hover.

  2. Refreshing the schema compare on demand

    Source Control for Oracle - Please do not run the refresing automatically when the app is openned. Run on demand when user click Reresh.

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

  3. Connection dialog data entry fields too short in some cases - particularly for database+instance

    It is not possible to see the entire database name in Schema Compare (and I think elsewhere)... The text fiield is too short. Have a screenshot if desired.

    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…)
    5 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

  4. eduardo.torres@deinos.com.ar

    descargo el data compare for oracle en version trial...
    no me funciona porque algun motivo, entiendo que puede ser que necesite la version de 64 bits, pero no la encuentro por ningun lado...entonces les escribo y no me deja enviarle la solicitud porque me dice que tengo que poner una licencia...
    es trial amigo...como hago....

    les agradeceré si se pueden poner en contacto conmigo...
    gracias.

    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 →
    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
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    When you install Data Compare for Oracle, it should install both the 32 and 64 bit versions.  You should see them in the Start Menu.  If you are still having issues, please contact our support team. 

  5. Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle?

    Why/where I can't use "Schema Compare for Oracle" tool Option (Behavior, Ignore) and Filter Setup in Source Control for Oracle? Two tools behave like same and give same structure

    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 →
    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. Local git repository - a documented example

    Could you post somewhere an example of Source Control with a local git repo? I have done "git init --bare" but sitll get this:
    Git directory must be an existing bare repository, for example 'git init --bare'

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

    We did have an issue that we fixed in the latest release to do with using a file uri rather than a path. But I don’t think this is your issue.

    So eg
    C:\>cd tempora

    C:\tempora>mkdir test

    C:\tempora>cd test

    C:\tempora\test>git init —bare
    Initialized empty Git repository in C:/tempora/test/

    Then link to “c:\tempora\test” in the first box and leave the second box empty or not and it works (for me anyway).

  7. Data Compare for Oracle: Option: Comparisaon behavior - Trim Trailing Spaces: Is it possible to uncheck by default this option?

    When I used this tool, I want that, by default, he copies over all data exactly the same as they exist in the source; so including trailing spaces.

    In my opinion you set/change an option if you want that your data should be 'transformed' during the transfer form source to target. At that moment, it is a conscious choice.

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

    Hi Jan,

    I’m going to close this as David mentions you should be able to save your default comparison options. Do let us know if that isn’t the case.

    Michael

  8. NEXT /*1:Days*/ sysdate + 1 in Materlized View in Database not in Source Control SVC

    Bug, /1:Days/ in Database Version, not in SVC therfore always x number of mv objects to check in and when try to check in will not update matrialized views

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

  10. 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 →
    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
    completed  ·  Neil Anderson responded

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

  11. 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 →
    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. Add support to ORACLE_LOADER and ORACLE_DATAPUMP access drivers

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 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

  13. TFS client not found

    I'm getting an error that TFS client not found. I don't see any documentation as to what the RedGate software is expecting to see as a "TFS client". Please advise.

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

    An alternative to needing Visual Studio installed is to use Team Explorer or Team Explorer Everywhere

  14. The code comparison window should be resizable vertically.

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

    Thanks Leigh, this should now be the case in the latest beta release

  15. Match source when creating repository files.

    When checking in a new package from the database, the schema name in references throughout the package is changed to have double quotes around it. Then when a change is made on the file, the entries from the database without the double quotes do not match the entries from source control with the double quotes. It seems that this difference alone isn't enough to show the comparison as different, but when another difference exists, these entries are all flagged as different. To resolve this, the double quotes should not be created in the first place.

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

    Thanks Leigh. We believe this is fixed in the latest beta release, please do advise.

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

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

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

  19. 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 →
    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
    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)

1 3 Next →
  • Don't see your idea?