Database Administrator

Install MySQL server and client in Ubuntu 14.04 Now the software in Linux is getting better and better to install, especially when installing software in Ubuntu, It is not skillful. You only need to use apt-get inatll when connected. Before deciding

Notes for getting records using rowid and rownumWe know that rowid and rownum can be used as fake and shoddy in Oracle and are mainly used to locate specific records in the table, but they are different, rowid corresponds to the physical address of

Considerations for installing MySQL source code scr. rpm The rpm installation package is usually a Binary package or a Source package. When using the source code to install MySQL, the source code package downloaded on the official website is usually

Incorrect upgrade leads to ORA-27468 errors and full flashback (ORA-16014) ORA-27468 error in Oracle 10.2.0.5 environment Alert Log. View alert logs: Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:ORA-12012: Automatic job 5329

Examples of sqoop and sqoop Description: sqoop is a tool that can import data from ORACLE and MYSQL to HDFS, HIVE, and HBASE (or vice versa. The following are some examples. Leave a reference: # Extracting data from Mysql to HDFS. Problem: too many

Comparison and analysis of various temporary tables and Efficiency ComparisonComparison and analysis of various temporary tablesOld Shuai (20141107)When writing a stored procedure, temporary tables are often used. What kind of efficiency is better

ORACLE tree query and oracle tree Query The front-end tree structure varies according to personal permissions. For all my queries, You need to query all the subnodes and the information of the current node based on the tree ID. Select * from table

The Processing Mechanism of redis after the hard disk is full, and the mechanism of the hard disk redis The hard disk Of A redis machine was full the other day, mainly because of program bugs that led to a surge in backup volume, and the monitoring

For the SQL field "include" and "include" stringZookeeper 1. Method for querying all records whose field value "contains" a string If the table has a name field and the query name contains all records of "Zhang San", you can write the SQL statement

The length of Chinese Characters in Oralce and the length of oralce Chinese Characters Generally, we use the String. length () method when verifying the String length at the Java layer. The returned length is the same in both Chinese and

Principles and Examples of distributed transactions Abstract: in software development and database operations, it is often necessary to advance and retreat together, either to succeed together or to fail together. Case study:A Transfers 3000 RMB to

Oracle set operation functions: Union, Union All, Intersect, Minus, intersectminusUnion: Perform Union operations on two result sets, excluding duplicate rows, and sort the default rules at the same time;Union All: Perform Union operations on the

How can I view others' consumption records? QQ1622863529Query serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries, delete QQ chat records, modify QQ chat records, and delete chat

Whether the maximum number of connections is set in oracle or an error is returned. There are 1100 data records to be updated, and an error is reported during connection. ORA-12518, TNS: listener cocould not hand off client connection According to

ORA-12518: TNS: listener cocould not hand off client connection, ora-12518tns 1. ORA-12518: TNS: listener cocould not hand off client connection When the number of team members increases, problems such as "unable to distribute client connections"

Delphi (Tuxedo, BDE, ADO) three-in-one dataset component HsTxQuery and tuxedohstxquery Delphi (Tuxedo, BDE, ADO) three-in-one dataset component HsTxQuery I. background Why is this three-in-one dataset component required? In the past, most of the

Oracle Installation Error: environment does not meet requirements solution, oracle times In the past, I often encountered this problem when installing Oracle, and I didn't care too much about it. I modified the cvu_prereq.xml file under the client \

Configuration steps for mysql dual-machine hot standby and mysql dual-machine hot standby Set dual-machine Hot Standby: First, you must create a synchronization user on the two machines: Grant replication slave on *. * to 'repdcs '@ '192. 168.21.39'

[Mysql] Mysql database processes Chinese characters transmitted in Servlet, mysqlservlet The default encoding of many Mysql instances is latin1. If Mysql does not change the encoding during installation, it cannot be entered into Chinese directly

Online query of synonyms and synonyms 1. Create: -- Create the synonymCreate or replace synonym CPS_ROLE_PERMISSIONFor CPSSYS. CPS_ROLE_PERMISSION @ ORA11G @ UCC_BICP;   2. View Select * from all_objects t where t. owner like 'lbi _ % 'and t. OBJECT_