16 results found
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
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
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
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
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%…1 vote
Hi , I am trying to understand how to introduce a pre-script ALTER SESSION SET CURRENT_SCHEMA = <> SQL statement in the top of the deployment script which is generated during the schema compare either between source DB vs target DB or TFS vs Target DB.4 votes
It's less an idea than a complaint. I'm a seasoned DBA working with a large number of developers. Developers do not have elevated privilege access to our QA or production environments. I'm wanting to set up a wallet so this tool can access those environments without requiring login/password information. I've setup sqlnet.ora and ldap.ora (we don't use tnsnames.ora) and can connect via the wallet entry using SQL*Plus on my local machine without issue. However, your product (Schema Compare) fires off an ORA-01017 (invalid login/password). Yet when I use normal credentialed login procedures via Schema Compare, the test works just fine.…1 vote
This has been an issue with Oracle tools for some time.
A table with a Generated column has a bug which inserts an extra right parentheses in its definition. Can be seen in Source Control as well as Schema Compare.
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1)) NOT NULL,
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1))) NOT NULL,2 votes
When installing Source Control for Oracle, be able to set / configure where the WorkingBases and Transients folders are created.
By default, Source Control for Oracle creates the WorkingBases and Transients (along with other associated files and folders) in the users Windows profile (C:\Users<user name>\AppData\Local\Red Gate\Source Control for Oracle).
In some environments the C: drive is configured to be minimal size (just OS and some required applications).
Being able to configure the paths where the WorkingBases and Transients (along with other associated files and folders) would to free up disk space in environments where the C:\ is configured to minimal disk space.11 votes
Hi in my organization we are using gerrit codereview as our source control repository. Could you please add your oracle tools to support Gerrit codereview ?3 votes
Allow to create a migration script from Oracle tool. (exists some alternative solution now?)1 vote
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.
Dialogs for connection strings should permit pasting an EZCONNECT string and just using it.1 vote
the ability to broadcast releases/upgrades is in the Multiscript tool...but only for SQL. Please implement for Oracle! Potentially hugely beneficial for some real-world cases1 vote
often when I am going through a compare or check in list, I am looking at changes and looking for a set of changes to check in, or a set of changes to make a script for. As I'm going down the list, I would like to just remove matches as I go. Sometimes I want to remove a whole block, then resort by something else then remove another block, so I can quickly narrow results down (and often don't want to create a filter for this, becuase it changes, this is more of a one time thing). Now if…3 votes
Just to confirm this is because the list doesn’t currently allow multiple rows to be selected currently. Correct?
Why i must create the same connection in each tool again? Please save connection strings global for all your tools and let me select the connection i need from a list within each of your tools.24 votes
Various issues could be avoided by allowing indexes to be ignored when comparing.2 votes
- Don't see your idea?