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

  1. Since you can't update the values, why compare them in the first place?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  2. The Azure DevOps extensions for SQL Server allow you to build the solution on check-in of new code without needing a target database to build against. Having similar extensions with this ability for Oracle to match what we can do with SQL Server would be fantastic.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  All Oracle  ·  Flag idea as inappropriate…  ·  Admin →
  3. We use DBMSRLS to filter data based on the Oracle Context object. The context is set using a login script which is then used as part of a table policy. More information is available at https://docs.oracle.com/cd/E2469301/appdev.11203/e23448/d_rls.htm#i1004716.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  All Oracle  ·  Flag idea as inappropriate…  ·  Admin →
  4. This presents a problem for fully capturing table DDL definitions that are selected for the comparison

    It is not immediately clear, and may be difficult to detect that FKs are excluded / failed to be captured, unless a full / unfiltered schema comparison is performed.

    There is no indication that the FKs are suppressed and no setting will include them.

    Are there any Schema Compare for Oracle and / or Source Control for Oracle users who would like to see the FK keys that reference Ignored Tables to be included in the deployment script or recorded in the DDL for…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Would be nice to be able to include projects into fresh groups -- so group or similar projects could be refreshed together.

    Individual refreshes may become tedious, and the Refresh All may be too broad.

    Alt as a simpler implementation provide the ability to exclude projects from a bulk (Refresh All) -- e.g. by marking a project as inactive.

    Example:
    If I have 15 projects total:
    - 5 defined as belong to Group A,
    - 4 belong to Group B,
    - 4 are unaffiliated
    - 2 are inactive

    Would like to be able to:
    - refresh Group A (project count:…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  6. Sometimes in non-PROD environmens vs prod we may want to have different increment by clauses on sequences.

    e.g. increment by 3 on non-Prod but increment by 1 on Prod

    Would be be nice to be able to ignore differences in the increment by clause as an ignore options (similar to the ignore option for sequence current value)

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow for manual ordering (e.g. drag and drop and/or move up / move down functionality) for Source Control Projects (vs. by name only)

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  8. Our QA department will need proof to show that the exported Oracle 11 data is the same when imported to Oracle 12 due to the strict GMP regulations that we need to be compliant with as pharmaceutical production facility.
    As the Oracle database is part of software from a vendor we don’t do any development with Oracle. We only need the Oracle data compare tool for making sure that with the upgrade of software, the Oracle 11 data is the same as the imported data in Oracle 12 (before the new software will be installed).
    The Oracle compare tool has…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  9. Hi,

    When Using a Range Splitted Rule and one wants to auto generate the different ranges, damasker is launching following query (I will write just an example):

    Select MIN(NUMERICFIELD) from MyTableToBeSplitted
    UNION ALL
    Select MAX(NUMERIC
    FIELD) from MyTableToBeSplitted

    This will involve reading table twice (being the default plan through FULL TABLE ACCESS or INDEX).
    Talking about big tables (which are the favourite target for Range Splitted Rules), this is too much time.

    Instead, perhaps query could be changed to the following:

    Select MIN(NUMERICFIELD) , MAX(NUMERICFIELD) from MyTableToBeSplitted

    This will improve time spent, reducing it by a 50%…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  All Oracle  ·  Flag idea as inappropriate…  ·  Admin →
  10. Please support proxy users. They allow people to impersonate another user which is useful for all kinds of purposes regarding security and auditing.
    So, I got this user called MyUserName which can act as a proxy user for OurSchema. To log in, I use MyUserName[OurSchema] as the username (and my own password). Then I can make modifications to OurSchema and basically work as if I'm logged in as OurSchema.
    This works well in any tool. In Schema Compare it almost works, but there seems to be an issue with the grants. The grants are not detected, so when I run…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  11. constraints are not treated as separate objects in oracle schema compare,

    without that, how can we compare constraints alone in a database ?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. CREATE TABE FOO of BAR

    If I create a table (FOO) of an object type (BAR), this table is not picked up by schema compare. This is probably because it's not listed in USERTABLES, but in USEROBJECT_TABLES.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  13. Currently when using Data Compare for Oracle 4 if any INSERT/UPDATE throws an error in a PL/SQL block the entire block fails. Because of this the company I work for will not use the software for DML deployments. If Redgate could code error handling for each table or each block where the script will continue to update/insert SQL data even in the event of an error the software would be much more usable, robust, and practical. Thank-you for reading this. :) Please add error-handling to the DML code that is generated in the diff/sync scripts.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  14. Ability to tick multiple items and resolve when faced with lots of conflicts

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  15. With the “Exclude Schema Names” option enabled, SCO identifies false-positive mismatches for public synonyms.

    In Oracle public synonym DDL w/o owner specified defaults the object owner to current user.

    CREATE PUBLIC SYNONYM foo_bar FOR bar
    /

    SELECT *
    FROM allsynonyms
    WHERE synonym
    name = 'FOO_BAR'
    /

    SCO happily generates the Public synonym DDL w/o the owner specified (and it can be executed as such). However, on subsequent comparisons the underlying object’s qualified name is used and the public synonyms are all identified as being different.
    e.g. CREATE OR REPLACE PUBLIC SYNONYM foobar FOR myschema.bar vs. CREATE OR…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  16. When I look at RedGates local files, it has downloaded my whole solution. Shouldn't it just be getting the files in the database folder I specified? For bigger projects this takes a long time.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  17. When entering ignore mask into PublicSynonym section, the ignore does not work - all public synonyms are still compared. But if the same ignore mask is entered into Synonym section, public synonyms are affected.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  18. Please add advanced filtering in Schema Compare. E.g. wildcard or regex matches to only show objects matching a certain criteria.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
  19. The current command line option runs but produces no output until the entire compare is completed, the GUI tells you what table it is on and the % complete. The batch process should be able to do the same.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
  20. If the SQL parser could read DDL generated by other tools (e.g. data modeling tools), then the schema comparison could find differences between the schema as defined by those tools versus a database.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7
  • Don't see your idea?