Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
Im creating database in oracle 12.2.0.1 on windows 2012 r2 64 bit and Dbca hangs at 59% of completion in db clone step.I've checked the dbca logs and it's...
Asked on 12/06/2020 by user133197
0 answerI'm using MySql 5.5.Is it possible to change expire_logs_days and have the changes take effect without restarting the server?...
Asked on 12/06/2020 by Ran
4 answerWe have a configuration file at E:SQL_Server_2016_InstallMyConfigFile.ini that looks like below:[OPTIONS]ACTION = "Install"FEATURES = SQLENGINEINSTANCENAME = MSSQLSERVERAGTSVCACCOUNT = "MyDomainMyAccount"SQLSVCACCOUNT = "MyDomainMyAccount"QSIACCEPTSQLSERVERLICENSETERMSSQL Server is then installed using below batch file:...
Asked on 12/05/2020 by Aleksey Vitsko
1 answerI am working on a project where I need to collect as many SQL performance metrics as possible, all from system views. I currently have collected, and in parenthesis the...
Asked on 12/03/2020 by Monya Feldman
1 answerI have an Informix Database and a Microsoft SQL Server 2016.My task is to dump the whole Informix Database and export it to the Microsoft SQL Server Database.I...
Asked on 12/03/2020
1 answerI am looking for best practices for how to share data from a SQL Server database that contains PHI/PII to individuals that cannot view PHI/PII. In short, we maintain a...
Asked on 12/03/2020 by MartyB
2 answerIt is a Java and Hibernate based application that processes rows in a table. The application when launched loops through rows in a table, executes anywhere from 10-25 queries per...
Asked on 12/03/2020 by Raghu Mutyam
0 answerI have a function in SQL Server 2019 that copies data from a local table to an Oracle 11.2.0.4 table via Linked Server, using Oracle 19.3 client. Recently, a new...
Asked on 11/30/2020 by CaM
1 answerAs part of a system upgrade I need to sync a database between 2 different servers (master-master). The catch is that the structure is slightly different between the 2. Most...
Asked on 11/28/2020 by SPKSmithy
1 answerI have recently come across a situation where I am required to restore an ODBK file. Basically this is a database file of Intergy Server (An EHR platform). I don't...
Asked on 11/14/2020 by Hasnain
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP