Database Administrator

How to insert special characters in Oracle: & and '(Multiple Solutions) When importing a batch of data to Oracle today, I encountered a problem: Toad prompts me to assign a value to a custom variable AMP. At first I was wondering that data is a

Refresh a simple passwd file for linux commands and passwd for linux commands **************************************** ******************************** *************************************** Original Works are from the blog of "Deep Blue blog". You

Relationship Pattern Design Theory and Pattern Design Theory Normalization: A low-level paradigm can be transformed into a relational model of several advanced paradigms through Mode Decomposition, that is, normalization. Paradigm: Currently,

MySQL character encoding problem, Incorrect string value, mysqlincorrectAn error is reported when inserting Chinese Characters in MySQL. For details, refer to the analysis below.Incorrect string value: '\ xD0 \ xC2 \ xC8A \ xbew' for column 'ctnr'

[MongoDB] Serveral common command of MongoDb, mongodbserveral In the recent days, since the overwork made me exhaused, on arrival to home I will go to bed, which leads to loss of blogs that shoshould have been written in the past days. Now I make a

1. What is registration? Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users

Principle and Practical Application of memcache, and actual application of memcache What is Memcache?Memcache is a danga.com project that was first used for LiveJournal. Many people around the world use this cache project to build their own websites

PLSQL Developer can synchronize table structures and table data of different databases. The Tools Options in the PLSQL Developer menu contain the Compare User Objects and Compare Table Data functions. 1. Tools --> compare user objects This function

There are three main methods for MySQL Data Synchronization: 1. Use the MySQL database synchronization function2. Use the features of the MySQL database (the database has a fixed directory and is stored as a file) To synchronize the database

Sqlite Study Notes 1: Compile the database and sqlite Study Notes First, I am using a Linux environment. 1. Download source code Download from the official website: click here Second compilation 1. Decompress After the download is complete, it is

Inaccurate MySQL execution plan-Overview, mysql execution plan The execution plan for the Mao MySQL optimizer is often inaccurate, but not optimal (cpu + io )??? Too many factors :: The information of information_schema is regularly refreshed. In

9-non-connection mode of ADO. NET, DataSet in memory, DataTable --- ShinePans, DataSet is called a DataSet. It can be compared to a database in memory. DataSet is ADO. NET core, supports ADO.. NET disconnected. The core object of the distributed

Storage Structure and transactions, storage structure transactions The restructured data center charging system is implemented by three layers. When I started simple addition, deletion, and modification, I was able to say that I had to learn

How to Use JDBC to start Oracle auto trace, jdbcoracleSometimes we need to track and analyze the specific execution process of SQL statements, especially when the application performance is optimized. Two Oracle tools can help us analyze performance.

Solve the problem that MySQL cannot be fully detached when the mysql service cannot be started in windows. MySQL Solution The following articles mainly describe the actual solution that cannot be fully detached when the MySQL service cannot be

Establish RAC in AIX (1) detection system environment, aixrac Establish a series of RAC instances under AIX Environment Node Node 1 Node 2 Small Machine Model IBM p-series 630 IBM p-series 630 Host Name AIX2

Nomorlization) 1NF: atomicity, that is, each field cannot be separated. 2NF: uniqueness, that is, each table describes only one entity. This entity must have a primary key. non-primary keywords must be fully dependent on the primary key because

I. The following error is reported when 10gRAC uses DBCA to reconstruct asm:The ASM instance configured on the local node is a single-instance ASM. to create a single-instance database using this ASM instance, restart DBCA and select the

Record a problem. Shutdown immediate appears SQL> shutdown immediate ORA-00600: internal error code, arguments: [2032], [12587038], [12587038], [8192], [2], [255], [0], [767], [], [], [], []   And when the data is inserted ORA-01110: data file 3:

1. Automatic growth of identityApplicable to MySQL, DB2, and ms SQL Server. It uses the primary key generated by the database to generate unique identifiers for long, short, and int types.Use auto-increment fields of SQL Server and MySQL. This