Database Administrator

ORA-01658: Unable to create INITIAL partition for segments in tablespace space Error When imp imports data: ORA-01658: Unable to create INITIAL partition for segments in table space MAXDATA An error occurred while creating a table in Oracle: ORA-0

CentOS6.2 download and install MongoDB 3.0.4 CentOS6.2 download and install MongoDB 3.0.4 1.: wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.0.4.tgz 2. Unzip and install Tar-zxvf mongodb-linux-x86_64-3.0.4.tgz Music mongodb-linux-x86_64-

Oracle string operation functions Character function -- returns the character value All these functions receive parameters of the character family type (except for CHR) and return character values. except for some special descriptions, most of these

MySQL Log File Type Introduction: MySQL provides various types of log files that reflect different MySQL information and are necessary to understand them. 1. Error log (Error log) The error log records all severe warnings and error messages during

Install and use Redis in Linux What is Redis? Redis is an open-source log-type and Key-Value database written in ansi c language that supports Network, memory-based persistence, and provides APIs in multiple languages. Redis is a key-value storage

Install MongoDB 3.0.2 in 64-bit CentOS 6.2 Mongo is easy to manage using yum, as long as you create/etc/yum. repos. d/mongodb-org-3.0.repo, write: Mongodb-org-3.0Name = MongoDB RepositoryBaseurl =

Install MySQL 5.5.35 in the source code of Ubuntu 14.04 The Ubuntu-14.04-desktop-amd64 is installed. During this process, I made a low-level error. When I installed the partition in Ubuntu, I divided the partition in free space. However, the windows

The skip_constraint_errors option of Oracle impdp skips the unique constraint error. In the past, impdp imported to an existing table has a unique index, and the data to be imported has a unique conflict with the current data. the general solution

Install Redis in LinuxPrepare to install and run the command: tar zxvf redis-3.0.4.tar.gzEnter the decompressed Folder: cd redis-3.0.4Compile source code: makeIf the following error occurs: [root@localhost redis-3.0.4]# makecd src && make allmake[1]

Try Redis: getting started with RedisOpening Redis is a NoSQL database that stores data using key-value pairs. Key-value pairs store data based on a key. Then you can use this key to retrieve the stored value. AvailableSETThe command uses the key

MySQL read/write splitting using MyCAT MyCAT is a database middleware developed based on Alibaba's open-source cobar product. It is jointly developed and open-source by several talented people with lofty ideals. Provides highly available data

SQLite3 simple operationDirectory 1. Create Database Files 2. operate in the sqlite3 prompt Column 3. SQL command format 4. Create a data table 5. Create an index 6. Add a document 7. query data 8. How to change or delete Materials 9 other

Oracle 11g RAC manual gi psu patch (11.2.0.4.8)I. Preparations 1. database environment Operating system version: RedHat 6.5x64Database Version: Oracle 11.2.0.4 x64 RACGrid: 11.2.0.4Oracle database: 11.2.0.42. Prepare the content Gi psu: p21523375_112

MySQL Partition Table Management I. How to manage RANGE and LIST partitions This partitioned table is used as an example. CREATE TABLE members ( id INT, fname VARCHAR(25), lname VARCHAR(25), dob DATE)PARTITION BY RANGE( YEAR(dob) ) (

Access the Oracle server through SQL J of DB2 Today I saw a book about Oracle SQLJ, so I want to give it a try. However, I only installed the Oracle thin client on Ubuntu 14.04. There is no SQLJ, so the sqlj thought of using the IBM-db2, it was

Inconsistency of master-slave replication data in MySQL In the master-slave replication architecture, the default replication method of mysql5.6 is SBR (SQL statement-based replication ), if the context of the Master/Slave database is inconsistent

Comparison of write time consumption between MongoDB3.0.6 wiredtiger and MMAPv1 EnginesI. Business Requirements: the database of an APP of the company has vertically separated logs from the business, splitting the original RAC into two sets.

Manual cleaning of Oracle audit records Oracle Database Audit is very powerful, usually including standard audit (including user-level audit and system-level audit) and fine-grained audit. Even so, it is easy to cause performance problems if you are

Oracle 12c In-Memory in Tablespaces As mentioned In the previous article, you can enable In-Memory at the table level. In fact, you can also enable Tablespaces at Tablespaces level, in-Memory is also enabled for all tables stored In Tablespaces. Let'

Percona MySQL5.6 semi-synchronous Replication Configure normal clone first Two servers, one master and one slave Master Server: 10.10.1.30 Slave: 10.10.1.200 Modify the my. cnf file of each machine and the server_id Master server server_id = 1,