Database Administrator

Error logs recorded during DML Process When you insert millions of data records, the insertion fails due to several dirty data records. Oracle 10g R2 has a new feature that inserts records that failed to be inserted into another table. SQL> drop

Generate multiple ADDM reports in Oracle I have written an article in Oracle to generate AWR reports () in batches. We used to monitor AWR reports every day to eliminate potential performance risks in a timely manner. Now there is another way to

Solution to ORA-01417 under Oracle 11g Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This

What should I do if I forget the ROOT password of MySQL ?, Mysqlroot Password1. Open Command Line in CMD, enter net stop mysql, and stop MYSQL service.   2. Enter the MySQL installation directory (for example, you put in E: \ mysql-5.6.14-winx64

Before the business system stress test, Oracle dba must complete the work in advance. oracledba This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661 Before the business

Oracle groups fetch the first data in each group, and oracle groups select * from test; No Time Name 1001 20141226 Zhangsan 1001 20141227 Lisi 1002 20141228 Wangwu 1002 2014122

Innobackupex-based full recovery and Innobackupex-based recoveryFor full MySQL recovery, we can use Innobackupex's multiple backups and binlog to restore the database to the fault point. Here, full recovery is relative to point-in-time recovery

Specify the date to query the number of Oracle databases and specify the date to query the oracle database 1. First, introduce the to_char function. TO_CHAR converts a date or number to a string and cannot specify the string length.Use the TO_CHAR

Note When upgrading Oracle GoldenGate, oraclegoldengateThis article is the original article, reprint please indicate the source http://blog.csdn.net/msdnchina/article/details/42046205Oracle GoldenGate is being upgraded recently. refer to the

[Useful for volume opening] record the process of solving deadlocks under a high concurrency, and give useful ideas on volume opening It is helpful to open the exam. I haven't written a blog for a long time, and I have been busy working

Linux SQL statement concise tutorial --- HAVING, concise tutorial --- having How can we set conditions for the values produced by functions? For example, we may only need to know which stores have a turnover of more than $1,500. In this case, we

A concise tutorial on SQL statements in linux --- UNION ALL, a concise tutorial --- union UNION ALLThe purpose of this command is to combine the results of two SQL statements.UNION ALLAndUNIONThe difference is thatUNION ALLEach qualified item is

[Oracle] Chapter 3 index view sequence and Chapter 3 View Chapter 3 index view Sequence Sequences are database objects used to generate unique, continuous integers. A sequence is used to automatically generate a primary key or a unique key

Development: Software caused connection abort: recv failed, abortrecv Ibatis is widely used recently, and many small and strange problems have been encountered in the middle, but it has been quite difficult for me for a long time. Then record it:

Win7 + mariadb free installation version, win7mariadb installation version 1. Download mariadb-10.0.15-winx64.zip from the official website; 2. decompress the package to D:/mariadb; 3. Create a New my. ini file under the D:/mariadb directory. The

MySQL [ERROR] Table 'mysql. user' doesn' t exist, mysql. userexist A newly installed mysql source code, because the my-default.cnf was not copied to the/etc/my. cnf location, when starting mysql encountered an error that could not open the mysql.

Ssdb master-slave synchronous replication configuration detailed steps, ssdb detailed steps The SSDB configuration file is a hierarchical key-value static configuration file, which uses a TAB indent to represent the hierarchical relationship. The

Report software companies offer a high price reward for bugs. I am really drunk on 100 pieces, and I am bug100 pieces. I have been using FineReport, The FineReport report software of fansoft, for a long time, and have been paying attention to the

MySQL series: mini transaction and mysqlinnodb for innodb source code analysis Log is a very important module of innodb. There are two types of logs in innodb: redo log and undo log. The redolog is used for Data Exception recovery and Data

EF preliminary understanding, EF understanding EF stands for ADO. NET Entity Framework. It is an object-link solution developed by Microsoft Based on ADO. NET. Here, the object ing relationship is the program design model and database. EF integrates