Database Administrator

Solution for ORA-01033 due to accidental deletion of tablespace files This type of problem is usually caused by improper tablespace operations.Solution: SQL * Plus cannot be connected. The following error is displayed:ORA-01033: Oracle

ORA-00984: columns do not allow SQL parse error location here ORA-00984: The column is not allowed hereSQL parse error location When Oracle inserts data, it always prompts that the column is not allowed here. Online Search answers that many types

Oracle processes Clob data warehouse receiving (String warehouse receiving) You can search for a bunch of references from the Internet, either in unknown or not. You can load a pile of data into the database. Please refer to the final: Insert into

Combined Query of three MySQL tables Combined Query of three MySQL tables 1. Table Structure1. Image table (storing images) Create table 'tb _ pic '('id' int (11) not null AUTO_INCREMENT COMMENT 'auto-increment id', 'url' varchar (255) default null

MySQL 5.7 JSON support Recently, a business needs to store Json and perform some simple business logic processing. I have found that it is difficult to use mysql 5.6 for json data analysis. It is very difficult to simply store data. I have no way to

MongoDB full-text index usage How to create a full-text index for MongoDB:Db. ensureIndex ({key: "text "})Db. ensureIndex ({key1: "text", key2: "text "})Db. ensureIndex ({"$ **": "text", key2: "text "}) Usage of mongodb full-text index query:Db.

Oracle implements simple data desensitization through expdp remap_data Starting from Oracle 11g, The remap_data parameter is provided in impdp/expdp to convert data during import or export operations. if the production database data needs to be

Sqlplus/as sysdba cannot log on I recently read a question, but it was really strange to see it. It bothered me for a while.The background of the problem is to help developers solve a database problem. After the problem is solved, I want to perform

SQL Server 2016 RC0 installation (over multiple images) Microsoft's latest version of Database SQL Server 2016 launched RC0 in March 9, 2016. Multiple language versions are provided, including simplified Chinese, but the online books are still in

MySQL Replication-(Instance) Master-slave replication Principle MySQL Replication is an asynchronous Replication process that replicates data from the Master to one or more Slave instances. The entire replication process between the Master and

Use BBED for Oracle 11g Compilation Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Copy the missing file 2. Compile BBED 3. BBED Test Reference 1. Copy the missing file Several related files are missing in 11g, but we can actually copy the related

Clears MySQL Database Data Based on Field Conditions BackgroundAn online database has 1000 database shards and disk alerts. The size of each database is not very large, but the total size is very large. It is unrealistic to manually clean up data

Oracle 11G R2 uses RMAN to build the DataGuard Environment Environment: Role Machine name Operating System IP Remarks Master Database Db1 CentOS 5.11 x86_64 192.168.2.241 Install Oracle and create a database

MySQL · performance optimization · 5.7.6 InnoDB page flush Optimization In this article, we have introduced in detail the latest Optimization of InnoDB page flush by Oracle MySQL and Community branches. Further improvements have been made in the

Use the char type in Oracle 11g In Oracle data tables and program types, character types may be the most commonly used. Historically, Oracle first introduced a fixed-length char field, and then launched varchar2. Currently, mainstream Oracle

Use of DRA (Data Recovery Advisor) The official description of DRA: The simplest way to diagnose and repair database problems is to use the Data Recovery Advisor. This Oracle Database tool provides an infrastructure for diagnosing persistent data

Oracle Database Resource Management1. Understand Resource Manager terminology Three basic structures of Resource Manager: Resource user group, Resource plan (and auxiliary plan), and Resource plan wizard. The database resource manager can help you

MongoDB replication mechanism instance MongoDB master-slave replication is a master node that can replicate multiple slave nodes and master nodes. Here, one master node and one slave server use one database server to provide different ports. 1.

Integer Range in 32-bit and 64-bit PHP and MySQL A single byte has 8 bytes, so the 32-bit int type occupies 32-bit/8-bit = 4 bytes, And the 64-bit int type occupies 64-bit/8-bit = 8 bytes. 32-bit, 64-bit unsigned integer maximum value:2 ^ 64-1 = 184

MySQL new features-mysql_config_editor source code analysis Mysql has launched the encryption tool mysql_config_editor since mysql5.6. Previously, we put the account and password in plain text into my. cnf, so that you can log on to the database