Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 5

Oracle 11gR2 - How To Audit SYS.USER$ Table

I have a Oracle 11gR2 database and I want to audit all select operations on SYS.USER$ table for which users select on this table. When I try this command (I'm...

Asked on 12/26/2021 by jrdba

1 answer

Common entities with differing attributes across multiple databases

We have two systems each with their own database. Each system has Parties (Customers and Vendors) and each of these can have one or more Sites (addresses) for different functions...

Asked on 12/26/2021 by Rik Bradley

1 answer

SqlPackage does not pick up variables from profile

I want to upgrade a database using .dacpac and sqlpackage.exe here is how I run sqlpackage:SqlPackage.exe /Action:Publish /SourceFile:"my.dacpac" /Profile:"myprofile.publish.xml"The error...

Asked on 12/24/2021 by THX-1138

3 answer

This simple mysql query is taking 2-3 seconds

I'm using sqlalchemy and trying to do a query on an m2m table. I have a tag and want find all the events that match that tag:SELECT *...

Asked on 12/24/2021 by mikkergp

2 answer

Powershell Invoke-Sqlcmd Replacing £ with?

When I create a SQL Script that inserts the value '£' or '€' into a table the value on the table is a question mark (?)Though, when I insert...

Asked on 12/24/2021 by Dennis Finke

1 answer

how to nest query with avg and sum group by outer in MySQL 5.7

I have a dataset like this:tenant_code app_id reg_count 1 1 0 1...

Asked on 12/24/2021

2 answer

Something is totally wrong with my query. .. Slow. .. Why?

i have query with multiple JOINS and SUBQUERYS and it seems i have messed something up here. .. It did worked when there was low data (data is not even...

Asked on 12/24/2021 by Ingus

1 answer