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

    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. 

  2. 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)
    You have left! (?) (thinking…)
  3. For example, if I have several projects with multiple schemas in several databases, the Source Control for Oracle Tool may take several minutes to refresh the projects when the program opens. If I am only working on one database, I should be able to set the other projects to not auto refresh.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  4. With the release of Schema Compare for Oracle V3.1.3, the one Ignore Storage Option was split into 7 separate options (plus the Include All Storage Options). One of the 7 separate options is the “tablespaces and partitioning”.

    Please consider splitting the option into two separate options one for "tablespaces' and the other for 'partitioning'.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  All Oracle  ·  Admin →
  5. The filtering limitation to just “contains” is really frustrating and very time consuming.

    · How hard can it be to use one simple wild card (“” or “%”) to define patterns? That way I can specify a specific object name, i.e. “s” or all objects starting with, i.e. “s”, or any object containing, i.e. “s”, or any object ending with, i.e. “*s”. This would add so much for so little. This seems to be an enormous oversight and by far my single biggest frustration with the tool.

    · Not as important but useful would be being…

    18 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  ·  All Oracle  ·  Admin →
  6. 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)
    You have left! (?) (thinking…)
    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. 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)
    You have left! (?) (thinking…)
  8. 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)
    You have left! (?) (thinking…)
    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.

  9. 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)
    You have left! (?) (thinking…)
    5 comments  ·  All Oracle  ·  Admin →
  10. 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)
    You have left! (?) (thinking…)
    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.

  11. 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)
    You have left! (?) (thinking…)
  12. 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)
    You have left! (?) (thinking…)
  13. 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)
    You have left! (?) (thinking…)
    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.

  14. 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)
    You have left! (?) (thinking…)
  15. 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)
    You have left! (?) (thinking…)
  16. 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)
    You have left! (?) (thinking…)
    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.

  17. 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)
    You have left! (?) (thinking…)
    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 :)

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

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

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

← Previous 1 3
  • Don't see your idea?