TransWikia.com
  1. All Categories
  2. Database Administrators

Database Administrators : Recent Questions and Answers (Page 5)

Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.

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

PostgreSQL pg_restore: How do I save script report to a txt file?

I need to run pg_restore on my PC with Windows CMD to restore a dump to a remote DB. I need to save the running report of the pg_restore into...

Asked on 12/24/2021

0 answer

How to both reference and return a result set from a stored procedure in mysql?

I have read that a select query that stores a result into variables does not return a result set. Is there an efficient way to do both?BEGIN ...

Asked on 12/24/2021

1 answer

Upgrade Postgres 9.6 to 12

If I up to date my postgres from 9.6 to 12, can I get some issues with my queries? I'm afraid to have some problems with my actual code if...

Asked on 12/24/2021 by Doug P

0 answer

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP