Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I have Mongo installed on Ubuntu 16.04 machine, on VMWare. I start it using "mongo" command, last week there was no problem. But recently, it gives this error: MongoDB shell...
Asked on 02/12/2021 by jack jack
2 answerI created such table (similar to example from http://use-the-index-luke.com/sql/example-schema/postgresql/performance-testing-scalability )CREATE TABLE scale_data ( section NUMERIC NOT NULL, id1 NUMERIC...
Asked on 02/11/2021 by ALZ
2 answerI am new to PostgreSQL database. I want to upgrade the PostgreSQL version from 11.4 to 11.7. what are the steps involved can anybody tell. It will be helpful if...
Asked on 02/10/2021 by Nihar
1 answerI'm looking for a way of getting transactions from WAL files.Basically I need their LSN numbers.(ideally both transactions LSN numbers and WAL files first and last LSN numbers)...
Asked on 02/06/2021 by isxaker
1 answerHi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter...
Asked on 02/06/2021 by DavyGravy
1 answerSteps I have followed:-Created a physical standby database by using DUPLICATE TARGET DATABASE.Then checked the log gap between these two databases which was fine and in sync.After that standby database...
Asked on 02/06/2021 by Aritra
1 answerI've seen a few close examples here but I'm not quite getting something close enough for me to noodle out a fix. I have events, where trucks come in and...
Asked on 02/05/2021 by Trives
1 answerI have 2 existing tables: ‘projects’ and ‘units’.The two tables are connected through the project id. In the table 'projects' the column is called ‘id’ and generates every time a...
Asked on 02/05/2021 by Malks
1 answerI have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup,...
Asked on 02/04/2021 by John-Rock Bilodeau
1 answerWe have a db with around 150 tables in, of which about 30 or so are partitioned as such :ALTER TABLE `myTable` REORGANIZE PARTITION PFUTURE INTO (PARTITION P201910...
Asked on 02/04/2021 by FreudianSlip
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP