Database Administrator

When TOAD is connected to DB2, SQL1460N is reported. Tests should be performed between different versions of DB2 over the past few days. DB2 V9.7.4 64bit has been installed before, DB2 V9.7.6 has been installed after the test is uninstalled, the

Page processing of Neo4j graph data First, we will briefly introduce Neo4j. Neo4j is a high-performance NOSQL graphic database that stores structured data on the network rather than in tables, it is an embedded, disk-based, Java persistence engine

About the field-based fuzzy query method of MongoDB About the field-based fuzzy query method of mongodb Fuzzy query: tname contains a keyword Test' Cd/opt/soft/mongodb/bin ./Mongo -- host 192.168.0.1 -- port 17017 test Db. test_info.find

Oracle 11g system-level trigger to track drop misoperations Preface:The data in a table in the db is always disordered. I guess I 've experienced data synchronization operations such as drop and create, but no one knows where to operate it now,

Set Oracle 11gR2 to start automatically under CentOS6.5 Set Oracle 11gR2 to start automatically under CentOS6.5 1. Modify ORATAB as the root user (set N to Y ): [Root @ ora11gr2 ~] # Vim/etc/oratabMytest:/oracle/product/11.2.0/db_1: Y 2. oracle

Imp/exp Oracle Database Import and Export command Oracle Data Import and Export: imp/expFunction: Oracle Data Import/Export imp/exp is equivalent to oracle data restoration and backup. In most cases, you can use Oracle data import and export to back

MySQL storage engine features and selection suggestions Common storage engines of MySQL official storage engines include Innodb, MyISAM, Memory, Archive, NDB, and BDB. The most famous third parties are TokuDB, Infobright, InnfiniDB, and

How does MySQL export files with date format? A netizen asked how to use only SQL statements in MySQL to export files with date format. I thought it was a bit interesting, so I tried it. The exported file uses select into outfile, but the values

MySQL configuration file my. cnf added log parameter file Error MySQL configuration file my. cnf added log parameter file Error Add a line after [mysqld]Log =/tmp/mysql. logThen restart mysql,Shell> service mysql restartThen an error is

MySQL 5.7 cannot be logged on First, MySQL version 5.7 was released. The manager asked me to build LNMP with the latest version. Many problems were encountered during the setup process. Today, I will briefly discuss a problem with MySQL: After the

MySQL5.7.10 installation documentation 1. Install the dependency package Yum-y install gcc-c ++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison 2. Install the boost Library: First, check whether boost has been

Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 View the built-in python path and version of CentOS[Root @ oracle11g ~] # Which python/Usr/bin/python[Root @

Deep understanding of DB2 Tablespace (Tablespace) Tablespace is an important storage structure for establishing a ing between the logical structure of the database and the physical structure of the operating system in the database system. It serves

Upgrade Oracle 11.2.0.1 to 11.2.0.3 [Note] Generally, production databases do not use similar version 1 or R1 such as Oracle 11.2.0.1. 11.2.0.1 is the basic version, this version has more feature updates than the previous version, and feature

Oracle tracks common internal event numbers Oracle internal event numbers are often used to track the system status. How to use these internal event numbers requires events and experience. Only these commonly used internal event numbers are recorded

Filter MySQL slow query logs using commands An exception occurred on a web server.All requests are blocked due to CPU depletion, which may take 5 to 10 minutes. During this period, the overall database load is normal. Use the command to query slow

Summary of commonly used query statements in MySQL Development 1. query numeric data: SELECT * FROM tb_name WHERE sum> 100; Query predicate:>, =, ,! =,!> ,! , = 2. query strings SELECT * FROM tb_stu WHERE sname = 'cricode. com' SELECT * FROM

MySQL (ICP) index push-down comparison with Oracle The first time I saw this term, I thought of it together with Oracle FPD-filter push-down, but later I found that they were just the same thing, when an index contains all the access fields, you can

Spread knowledge, share happiness-MySQL database development and optimization video, share happiness-mysql Today is July 22, September 11, a memorable day, praying for innocent lives that have passed away! This year's 500 anniversary since the

In the Oracle11g database, dba_users has the password_versions column while oracle11gdba_users   Reference:11g R1 New Feature: Case Sensitive Passwords and Strong User Authentication (Document ID 429465.1)   The view DBA_USERS has new column