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.

129 results found

  1. Ignore SQL script files that fail to parse

    Add an option to ignore SQL files that fail to parse when the target is a Scripts Folder.

    I would like this, such that the tool can do autonomous exports without it crashing if the target contains valid but unsupported SQL like
    "DROP VIEW viewname
    CREATE OR REPLACE view    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…)
    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

  2. Option ILM POLICY

    Help, please, I compare tables but do not see ILM POLICY.
    The ILM POLICY option is enabled.

    Script:
    CREATE TABLE salesado
    (PROD    ID NUMBER NOT NULL,
    CUSTID NUMBER NOT NULL,
    TIME    ID DATE NOT NULL,
    CHANNELID NUMBER NOT NULL,
    PROMO    ID NUMBER NOT NULL,
    QUANTITYSOLD NUMBER(10,2) NOT NULL,
    AMOUNT    SOLD NUMBER(10,2) NOT NULL)
    PARTITION BY RANGE (timeid)
    ( PARTITION sales    q12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
    PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
    PARTITION sales    q32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
    PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
    );

    ALTER…

    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

  3. more features to add in interactive report html

    Hi, i have a question about interactive html report file. Maybe it is possible to add buttons in it like in schema compare for jumping between changes, because now its not really comfortable to navigate, when you have to scroll and find one change on big file. And finally you find that there is the difference only on space or tab. Also maybe it is possible to have alignment of code not on left side, but like in database - that spaces, tabs wouldn't be removed.

    Here is the link where i got answered to this question. But he just…

    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

  4. object history

    I would like to have the option (like in TortoiseSVN) to be able to check all revisions in which the indicated object was changed (either by name or by click). The history of the specified object would be very helpful.

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

    Currently, in the tool, we only show all the history.  If you use TortoiseSVN or another VCS client or command line, you can see the history for a particular object by locating that object's file in the repository and viewing that file's history.

  5. Add support for ANALYTIC VIEWS objects

    Currently the Schema compare for ORACLE doesnt support the below objects.
    1. ATTRIBUTE DIMENSION
    2. HIERARCHY
    3. ANALYTIC VIEW

    These have been available since Oracle12c. It would be nice for redgate to support all the Oracle object types from the latest database versions.

    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

  6. Locking and unlocking the objects in Oracle

    Hi Team,

    Lock and unlock the objects in oracle. Anyone can unlock and lock the objects, but our requirement it's should be configurable. some admin or some user has control to unlock the objects.

    For example, User ABC Locked the EMP tables currently anyone can unlock the objects but it's should either ABC user need to unlock or give some admin user to unlock the objects. We need to some control required to maintain the locking and unlocking the objects and there is no audit info as well.

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

  7. Virtual Columns Should Be Ignored By Default

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

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

  8. Add the ability to build without a target database

    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

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

  9. Add support for DBMS_RLS objects such as Packages and Contexts

    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

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

  10. Foreign Keys not included in comparison if referenced table is excluded by the Ignore Rules Filter

    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

    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

  11. Include option to create refresh groups (like Refresh Group X)

    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

    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

  12. Comparison Options: Add a Ignore option for Sequence Increment By

    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

    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

  13. Project Display Order

    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

    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

  14. QA department demand, according GMP rules, for proof of same data export-import

    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

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

  15. DataMasker for Oracle - Improvement for Range Split rules

    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

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

  16. Grants are not detected correctly when logged in as proxy user.

    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

    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

  17. constraints are not treated as seperate objects in oracle schema compare

    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

    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

  18. Support object tables

    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

    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

  19. Add Error Handling to PL/SQL Blocks

    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

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

  20. Multi-Select for conflict resolution

    Ability to tick multiple items and resolve when faced with lots of conflicts

    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
← Previous 1 3 4 5 6 7
  • Don't see your idea?