Database Administrator

Oracle online redefinition of DBMS_REDEFINITION normal table-> Partition Table Lab environment: RHEL 6.4 + Oracle 11.2.0.3Experiment: Online redefinition of a common table as a partition table, including the indexes corresponding to the primary key

Use the 10046 event to view the Oracle execution plan You can use the 10046 event to view the execution plan in the Oracle database and get the logical read, physical read, and time consumed by each execution step in the SQL Execution Plan. This

Oracle delete statement optimization example When I got up to work today, I received an email from the customer saying that it took more than three hours to execute a delete SQL statement in the production environment. Finally, the customer had no

PLSQL cannot identify ORACLE_HOME solution on 64-bit Oracle client 1. Problems PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. On 64-bit Windows, in most cases, the 64-bit Oracle client program

How MySQL uses set names to solve Garbled text We often use "set names utf8" to solve garbled code. Why can we solve this problem by adding this code? Next, let's dive into the internal execution principle of set names utf8. Let's talk about the

Mysql installation, start mysql service, connect local database and remote database, mysql remote I have taken a company project and I have to use mysql. Let's take a look ~! 1. Install mysql Download one from Baidu mysql.Pay attention to the

Backup _ imp import error due to inconsistent client and database versions Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Install mysql and machomebremysql in homebre on MAC 1. Execute the installation command Brew install mysql 2. The following bug occurs when mysql is input. ERROR 2002 (HY000): Can not connect to local MySQL server through socket

BI-SSAS practice, bi-ssas practice As the saying goes, "I have to get to the bottom of the paper, and I know that this is something to do." in the previous article, I briefly introduced SSAS, so today I will use an instance to understand its sense

Use the AMP (Alibaba Migration Platfrom) artifact to easily migrate data in the Oracle database to the MySQL database, migrationplatfrom Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44926187 Upload the AMP

Can't connect to local MySQL server through socket solution, connectmysqlFault description:Mysql startup error:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2) 1. Check the mysql startup status first.

MongoDB BASICS (add, delete, modify, and query) 1. Insert The insert Statement of MongoDB is in the following format: db.collection.insert(document) Document is the document data, and collection is the collection of document data. If the collection

[Translated from mos] flashback and flashback database, Flashback zone and flashback database Reference:Flash recovery area and FLASHBACK database (Document ID 369759.1) Applicable:Oracle Database-Enterprise Edition-Version 10.1.0.2 and

[Translated from mos] How to recreate the control file of the physical standby database, mosstandby How to recreate the control file of the physical standby database Reference:Steps to recreate a Physical Standby Controlfile (Document ID

. Net connection mysql database statement,. netmysql Database In my project, write the Connection database statement in the configuration file: Database is the database name, Data Source is the server address of the database, "localhost"

Redis 3.0.0 official version released, high-performance K/V service, redis3.0.0 The official version of Redis 3.0.0 has finally arrived. Compared with the RC6 version, the improvements include: * Oran Agra)* Test BLPOP replication after the role

Unicode: Garbled characters in the read database TCHAR cbContent [512];Dyn. GetFieldValue (0, cbContent, 512 ); // Garbled characters are displayed in Chinese AfxMessageBox (cbContent ); // Encoding conversionInt nBufferSize = MultiByteToWideChar

Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform), centosx64Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform)(Note: the current user is "tdtc100 ")1. down install files(1) linux.x64_11gR2_database_1of2.zip(

When the service is started, log4j prompts cocould not bind factory to JNDI, log4jjndi Log4j prompt when the service is started WARN SessionFactoryObjectFactory: 121-cocould not bind factory to JNDIJavax. naming. NoInitialContextException: Need to

Mysql learning starts from 0: Table creation and mysql learning Creation The following example shows a table named "persons: Id LastName FirstName Address City 1 Adams John Oxford Street London 2