Database Administrator

Comparison of PostgreSQL database backup and recovery technologies There are three completely different methods to back up PostgreSQL data: SQL dump File System-level backup Online backup I. SQL dump The pg_dump application tool is used to

Patch 11.2.0.3.4 P14275605 PSU for a single Oracle 11g instance 1. Close all instances SQL> shutdown immediate 2. Disable all listeners $ [Oracle @ ora_11g test01] $ lsnrctl stop 3. Disable all background sqlplus [Oracle @ ora_11g 14275605] $ ps-ef |

MySQL Stored Procedure A stored procedure is a set of SQL statements stored on the database server. You can run these SQL statement commands by calling a specified name in the query. Introduction The SQL statement needs to be compiled and then

The partition view joins the horizontal partition data from a group of Members to make the data look like it is from the same table. SQL Server 2000 distinguishes the local partition view from the distributed partition view. In the local partition

ORA-24247: Network Access denied access control list (ACL), ora-24247aclZookeeper ORA-24247: Network Access denied access control list (ACL)Note: The command must be used under the system user.You must first use DBMS_NETWORK_ACL_ADMIN.CREATE_ACL to

Database Installation Package and upgrade package script tool RedGate usage introduction, installation package redgate This log records the design of the database installation package I learned at the company. I have encountered some problems in my

The interceptor of mybatis implements statistical analysis of SQL Execution time, And mybatis performs statistical analysis. Reprinted from: http://blog.csdn.net/andyzhaojianhui/article/details/72823055 The idea of the interceptor for mybatis comes

[Translated from mos] asmcmd command is used to copy the asm file between the local and remote asm instances. asmcmdasm Use the asmcmd command to copy the asm file between the local and remote asm instances. Reference Original:How to Copy asm files

1. Create groups and users In linux, open the terminal and log on as the root user. Enter the following command: Groupadd dba // Add the dba group useradd-g dba-m oracle // Add the username as oracle and add the user to the dba group passwd oracle /

Last Review: This article mainly describes the Neo4j Spatial project and space data (vector) storage. This article describes how to integrate Neo4j Spatial with Neo4j Server and GeoServer. Noted: it is feasible to integrate with Geoserver, but

Tutorial on installing and using the extension module on PostgreSQL, postgresql extension module Installation Module Note: My runtime environments are Ubuntu 10.04 and PostgreSQL 8.4. First, install the postgresql-contrib package and restart the

The SQL Server Client Configuration tool is used to configure the client tool (except the DOS-based client tool) so that it can successfully communicate with SQL Server. This program should be run after the client tool is loaded. In most cases, you

Basic concepts: 1. Multi-dimensional dataset: a multi-dimensional dataset is the main object in Online Analytical Processing (OLAP) and a technology that allows quick access to data in a data warehouse. A multi-dimensional dataset is a collection

Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches", dba hardware manufacturers Original Works are from the blog of "Deep Blue blog". You are welcome to repost them.

The OS package and OS patch required for installing oracle database 10gR2 under Solaris 10 or later, sparc10gr2 Reference: Oracle Database (RDBMS) on Unix AIX, HP-UX, Linux, Mac OS X, Solaris, Tru64 Unix Operating Systems Installation and

Chapter 1 ocp exam guide and ocp exam Guide Database storage structure: Physical database storage structure: Three types of files are required: ControlFile: multiplexing the controfile multiplexing Control File,

S skills, Postgres skills If you need to add indexes when the business volume is large, you need to use CONCURRENTLY. Otherwise, your database will easily break down. For example create index CONCURRENTLY idx_order_records_bank_statist_uid on

In the process of using the iwms system, we often encounter data content replacement operations. Before telling you how to replace the data content, I suggest you first understand the data storage type of the SQL Server database: SQL Server Data

First, create a table emp1 with the same structure and insert some data for it. create table emp1asselect * from emp where deptno = 20; Update part of emp1 data update emp1set sal = sal + 100,comm = nvl(comm,0) + 50

Migration environment Configuration: Data source:BNET Development Environment Data Server:SunOS v880 5.8 Database:Oracle 9.2.0.4 & DB2 8.2 Migration tool:IBM DB2 Migration Toolkit 1.3I. Table migration 1. Index length limit In DB2, the maximum