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 SC with a proxy user, I suddenly get about 3000 differences.

   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… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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(NUMERICFIELD) 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% as table will only be read once.

   Thanks in advance,

   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(NUMERICFIELD) 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%… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  All Oracle  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  All Oracle  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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 said to register this question here:

   https://forum.red-gate.com/discussion/comment/168797#Comment_168797

   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… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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
   (PRODID NUMBER NOT NULL,
   CUSTID NUMBER NOT NULL,
   TIMEID DATE NOT NULL,
   CHANNELID NUMBER NOT NULL,
   PROMOID NUMBER NOT NULL,
   QUANTITYSOLD NUMBER(10,2) NOT NULL,
   AMOUNTSOLD NUMBER(10,2) NOT NULL)
   PARTITION BY RANGE (timeid)
   ( PARTITION salesq12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
   PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
   PARTITION salesq32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
   PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
   );

   ALTER TABLE salesado MODIFY PARTITION salesq1_2012
   ILM ADD POLICY ROW STORE COMPRESS ADVANCED ROW
   AFTER 30 DAYS OF NO MODIFICATION;
   COMMIT;

   ALTER TABLE salesado MODIFY PARTITION salesq2_2012
   ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT
   AFTER 3 MONTHS OF NO MODIFICATION;
   COMMIT;

   ALTER TABLE salesado MODIFY PARTITION salesq3_2012
   ILM ADD POLICY ROW STORE COMPRESS ADVANCED GROUP
   AFTER 6 MONTHS OF NO MODIFICATION;
   COMMIT;

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

   Script:
   CREATE TABLE salesado
   (PRODID NUMBER NOT NULL,
   CUSTID NUMBER NOT NULL,
   TIMEID DATE NOT NULL,
   CHANNELID NUMBER NOT NULL,
   PROMOID NUMBER NOT NULL,
   QUANTITYSOLD NUMBER(10,2) NOT NULL,
   AMOUNTSOLD NUMBER(10,2) NOT NULL)
   PARTITION BY RANGE (timeid)
   ( PARTITION salesq12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
   PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
   PARTITION salesq32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
   PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
   );

   ALTER… more

   •  

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

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 viewname"

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Schema Compare  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Migration script for Oracle tool

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

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  All Oracle  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   started  ·  AdminStephanie (Product Manager, Redgate) responded

   We have an Early Access Program for a migrations-first solution for Oracle version control and deployments. Please see more details and sign up at https://documentation.red-gate.com/ddfo/other-resources/migrations-based-deployments-early-access-program.

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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Data Compare  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close