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. 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
    1 comment  ·  Schema Compare  ·  Admin →
    How important is this to you?

  2. 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
    0 comments  ·  All Oracle  ·  Admin →
    How important is this to you?

  3. 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
    0 comments  ·  All Oracle  ·  Admin →
    How important is this to you?

  4. 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
    0 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

  5. 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
    0 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

  6. 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
    0 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

  7. 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
    0 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

  8. Migration script for Oracle tool

    Allow to create a migration script from Oracle tool. (exists some alternative solution now?)

    1 vote
    1 comment  ·  All Oracle  ·  Admin →
    How important is this to you?

  9. Allow Deployment wizard the ability to list or disable Foreign Key constraints

    When running the deployment wizard after a data compare rather throw error that database contains foreign keys in a cycle. It would be great if it listed the ones and allow you to disable them.

    0 votes
    1 comment  ·  Data Compare  ·  Admin →
    How important is this to you?
1 2 3 4 5 7 Next →
  • Don't see your idea?