Database Administrator

Restore Point and flash back database Flash back database and restore origin are two types of data recovery-related functions, they are used to replace restoration by time point to Cancel Changes to the database. Flashback allows you to roll back

Oracle index (notes) 1. Oracle index null When a single column index is created on an empty value column, if the search condition is null, it can be seen in the interpretation plan that oracle does not use index query for this column; However, when

Connect to the Oracle database without installing the Oracle client in Linux Connect to the Oracle database without installing the Oracle client in Linux 1. mkdir-p/opt/oracle2. cd/opt/oracle3. Go to the oracle official website to download the

Introduction to the use of with in Oracle subquery) Recently I have studied Oracle and want to improve the efficiency and ease of reading of statements I have written. Today's note is about subquery factors. Factor-based query may not necessarily

MySQL import data load data infile usageMySQL import data load data infile usage basic syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore]Into table tbl_name[Fields[Terminated by 'T'][OPTIONALLY] enclosed by

Configure master-slave synchronization for the MySQL database 1. Environment Description: DB master: 172.16.1.55DB slave: 172.16.1.562. Server-id configuration (/etc/my. cnf ):The master database configuration server-id is smaller than the slave

Oracle 10g RAC OCFS2 Cluster Storage migration Abstract In the RedHat 5.4 64bit environment of an Oracle 10g RAC ocfs2-Based Cluster, You need to replace the storage and upgrade the 8GHBA card. The process is summarized as follows: Preparation: 1.

Settings for automatic transaction submission by PL/SQL Developer Previously, the update table was used on a test machine. There was no commit or PL/SQL Developer. The next day, I checked the table on my computer and found that the record was not

Oracle11g OEM cannot connect to the database instance solution, oracle11goem My computer is 32-bitWin7 family EditionSystem, can such a system be installed with oracle? Yes! An error may occur. When installing oracle, everyone encounters different

Rewrite the oracle wm_contact function script and oraclewm_contact There is a requirement for a recent project to describe consecutive card numbers in one segment, for example, 1, 2, 3, 4, 5, 8, 10, 13, 14, 15, 16, to be displayed as 1-5, 8, 10, 13-1

JAVA connects to SQLServer basics and reads and writes 0.2 million data records (0.4 million operations) within five minutes. The qlserver First, the most basic connection method: private String url = "jdbc:odbc:Driver={SQL

The year, month, and day Field Values for the oracle date. The oracle Field Address: http://yanwushu.sinaapp.com/oracle_extract_year_month_day_valu/ Previously, we used to_char (timeField, 'yyyy') to obtain the year field value in the date. This

MySQL sets a self-starting fault solution in Ubuntu, mysqlubuntu A fault solution for Setting Automatic startup for MySQL in Ubuntu Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs When MySQL is self-started, run the

Innodb buffer parameters and viewing methods (to be continued), innodbbuffer Buffer parameters: Innodb_buffer_pool_size innodb_buffer size Innodb_buffer_pool_instances innodb_buffer instance count Innodb_old_blocks_pct LRU end mid Point

Shell operations on mongodb and shellmongodb Want to query MongoDB data through shell Many people on the Internet say that mongoDB does not support shell. I basically agree with this statement; But the project needs to be done, and I have to

DB2 database backup and recovery, db2 database creation Follow these steps to create a database in the Db2 environment: 1. When su-db2inst is missing, an error will occur; 2. db2 enters the db2 command line mode; 3. create database pb_db on/home/db2

[Leetcode SQL] Second Highest Salary, leetcodehighest The original question is as follows: Write a SQL query to get the second highest salary fromEmployeeTable. + ---- + -------- + | Id | Salary | + ---- + -------- + | 1 | 100 | 2 | 200 | 3 | 30

Database Concurrent transaction control 4: postgresql database lock mechanism 2: Table lock, postgresql database In the blog article "Database Concurrent transaction control 4: postgresql database lock

A Preliminary Study on compilation of oci and a preliminary study on oci0. Preface Let's continue with the story in the previous article and let us walk into the magical oci.I. Concepts of oci ORACLE Call Interface (OCI) provides a set of Interface

MySQL Server password retrieval, mysql password retrieval I recently used a server in the courtyard, but I don't know the MySQL password. However, I have to find a solution by myself. The process is very simple! First, enter the following