Database Administrator

Install Oracle database management software SQL Developer in Ubuntu 14.04 This is the second article about building Oracle Development Environment logs. Article 1: Build a PHP5 + Apache2 + Oracle environment in Ubuntu 14.04 This article will install

Changing the Linux host name causes MySQL to fail to start and restart MySQL cannot be restarted, shut down, started, or used. If you modify the host name, you can disable all MySQL processes and start MySQL. Today, I saw that my host name was

MongoDB replica set converts an existing single-node server to a replica set Server Status: Existing single-node Primary 192.168.126.9: 27017 New node Secondry 192.168.126.8: 27017 Arbitration node ARBITER 192.168.126.8: 27018 Mongo version 3.2.4 1.

Oracle snapshot standby database's scheduler jobs are not executed In Oracle 11g, the snapshot backup snapshot standby database feature of data guard is more suitable for rapid deployment of a temporary test database that is the same as the online

How does Mysql set the field to automatically obtain the current time? Application scenarios:   1. In a data table, to record when each piece of data was created, the data database automatically records the creation time without the need for the

In-depth understanding of MySQL 5.7 GTID series (II): GTID-related internal data structure, mysqlgtid Author:Gao Peng (Eight monsters in Chongqing) Original article address: Https://www.jianshu.com/p/5649644fdc13 I have a deep understanding of

PostgreSQL installation and configuration tutorial on Windows and postgresql installation tutorial PostgreSQL extension PostGIS is the most famous open source GIS database.Installing PostgreSQL is the first step. 1. Download the binary Installation

In-depth interpretation of sequences in PostgreSQL and their related functions, and interpretation of postgresql I. Introduction A sequence object (also called a SEQUENCE generator) is a special single-row table created using create sequence. A

Database questions-higher than the average department salary query problem, the average department salaryQuestion: find out the name, salary, Department number, and average salary of the employee higher than the average salary of the Department 1.

The SQLServer remote server does not exist. It is not specified as a valid Publishing Server, or you do not have permission to view available publishing servers. sqlserver does not exist. When a transaction release is created and an error occurs

The latest error message "unable to extend temp segment by 8192 in tablespace..." was prompted during rebuild index. This is a common error. When creating an index, you need to use the user's default temporary tablespace for sorting and generating

Java cannot directly insert Clob Data Types in Oracle, but it can write or read clob data in the form of a stream. The online code is not too much, I have summarized and summarized the online materials. For details, refer to the Code: Write clob

Install Hadoop in standalone mode-(1) install and set up a virtual environment for hadoop StandaloneZookeeper There are a lot of articles on how to install Hadoop in standalone mode on the network. Most of the articles that follow these steps fail,

MySQL Study -- Mysql startup failure "mysql. host", -- mysqlmysql. hostMySQL Study-Mysql startup failure "mysql. host" System Environment: Operating System: RedHat EL55 DB Soft: Mysql 5.6.4-m7 After mysql is installed through the source code

Import the Excel table data to the Sqlite database table, and import the data to sqliteImport the Excel table data to Sqlite database table 1. First, prepare the Excel file, open the Excel file, and save it as a *. csv file. 2. You need to create

SQLite tutorial (10): Memory Database and temporary database, sqlite tutorial I. Memory Database: In SQLite, databases are usually stored in disk files. However, in some cases, we can keep the database in the memory. The most common method is to

You need to know that the thread wait time is an important factor restricting the efficiency of SQL Server. This article will learn how to collect information such as the thread wait time and type in SQL Server, this information is the basis for

Oracle is a relational database management system with powerful functions and excellent performance. It plays an important role in today's large database management systems. Under normal circumstances, the Oracle database ensures data security and

In the design of database applications, we often need to obtain the total number of records in some tables to determine whether the total number of records in the table is too large and whether data needs to be backed up. Our common practice is:

When considering subjects such as primary Data Management (MDM) and Master Data Management, it is the only natural way to seek consultations from people who have already experienced or experienced primary Data Management. However, the best practices