Database Administrator

Meaning of Oracle create index on (colname, 0), oraclecolname Today, I saw an index, create index index_name tableanme (colname, 0). It's strange that I have never seen it before. After tests, it was found that it was an item relative to the Union

Oracle deadlock and oracle deadlockManually modify the record of a table. The following error is displayed:Then, try to use PL/SQL statements to modify the record. After more than 10 minutes, the record is displayed as being executed;Conclusion: The

Reconstruction-User Logon summary, reconstruction Summary At the beginning of the reconstruction, the master asked to implement a main line of login, and then gradually fill in according to this. There are many problems encountered in this phase.

ORA-00600 kcratr_nab_less_than_odr, ora-00600 In the morning, the database reports the following error: Successful mount of redo thread 1, with mount id 339694234Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER

Modify the sa authentication logon method in SQLServer, sqlserversa Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Modify the sa authentication logon method in SQLServer: 1. Find SQLServer Management Studio in the Start

Understanding Shared Pool 1 and sharedpoolThe Heap management shared pool is managed by means of Heap memory management (KGH: Kernel Generic Heap ). starting from Oracle 9i, You can have multiple TOP-level heap instances. The TOP-level heap

Simple operations in MySQL Linux (Service Startup and shutdown, startup and shutdown, view version), mysqllinux Today, the younger brother recorded the simple use of MySQL in the Linux system, as follows: Environment Linux: centeros 6.6 (as shown

SQL Server paging stored procedures, SQL stored procedures Paging storage process 1: --/* ----- Stored Procedure paging processing Sun Wei creation ------- */--/* ----- processed the data in two minutes so that the performance of the first half of

Build logical standby database by DG and build logic by dg The logical standby database is built on the basis of the physical standby database. Therefore, you must first set up the physical standby database. The slave database performs the

MySql character set learning and MySql character set learning 1. MySql CHARACTER set includes two concepts: CHARACTER set (CHARACTER) and validation rule (COLLATION. Character set is used to define the way MySql stores strings; validation rules are

ORA-02287: sequence number not allowed here is not allowed here to avoid and enforce implementation, ora-02287 here Scenario 1: SELECT id,name FROM (select SEQ_B_LOG_ID.NEXTVAL id , 'elong_deo' name from dual); Scenario 2: Insert into B

Use SQLData to read and write custom database types, and use sqldata to read and write custom How do I read and write custom types? SQLData is an intuitive solution Good information was found in the oracle user manual. Click Open

An error occurred while connecting winForm + access DATA. Microsoft. Jet. OLEDB.12.0, microsoft. jet. oledb, was not registered on the local computer. The Microsoft. Jet. OLEDB.12.0 provider is not registered on the local computer. 1. database

Oracle recursive query and Oracle recursive queryCreate a table and a primary foreign key CREATE TABLE SC_DISTRICT( ID NUMBER(10) NOT NULL, PARENT_ID NUMBER(10), NAME VARCHAR2(255 BYTE) NOT NULL);ALTER

MySQL configuration optimization (1) -- slow log query and mysql configuration optimization log(1) ERRLOG contains the related information when mysqd is started and stopped, and when the server encounters any serious error during running; you can

Simple details that those programmers will forget-db, forget details-db 1. Date plus dateadd (day, 1, '2017-12-31 ') 2. In the first few sqlervers, you can use top 1 mysql. None of them can only use limit. 3. The current date sqlserver is getdate

Full Set of Vue usage methods and vue usage New recruits transferred from an Oracle DBA to Mongodb follow the Oracle Learning Style Start to share some MongoDB management experience: 1. Export vue data After a normal connection, such as data,

Asian Cup with database creation-wish the Chinese team and the Chinese team for database creation 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,

PostgreSQL calls the stored procedure and returns the dataset instance. Here we use an instance to demonstrate how to return a dataset from a PostgreSQL stored procedure. 1. Prepare the data table first.Copy codeThe Code is as follows://

Data room charging system-storage process and charging system storage process A lot of things have been learned in this IDC charging system. E-R diagrams, views, stored procedures, triggers and more. All these things have been learned before, and