Database Administrator

The common thing about a database is that it stores data in a warehouse, and our operations on the database can be the same as what we store or take out in a warehouse. If we need to access things from a warehouse, first we need to know where the

Asm disk Group loading ORA-15183 error example In Oracle 11gR2, ASM (Automatic Storage Management) is removed from the Database Component, and as an independent Component, it enters the scope of Grid Management. This article mainly introduces a

The ORA-01940 cannot delete the user that is currently connected   When importing data in the test environment today, you need to remember the drop user operation. When you execute the drop user, the prompt is: ORA-01940: cannot drop a user that is

Pt-Online-schema-change of MySQL online DDL Tool MySQL DDL:DDL is a feature that makes all MySQL ddbas criticized, because in MySQL, when dDDL is performed on a table, it locks the table. When the table is small, such as less than 1 W rows, it has

It may be an ignored update Statement (update technique) or an update statement Well, I 've written a simple article again, and I hope you will not be enlightened. This time I want to talk about the update statement in SQL. Speaking of this, there

I. Mark data Log On with the scott user and set the tag data SQL> select table_name from user_tables; TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE EMP_BAK Creates a backup table emp_bak for the emp table. Ii. Back up the

Basic knowledge of SQL injection and basic knowledge of SQL Injection What is SQL Injection) The so-called SQL injection attack means that an attacker inserts an SQL command into the input field of a Web form or the query string requested by the

How to convert Access to SQL database, and convert access to SQL database First of all, I am talking about the conversion between ACCESS2000 and SQL2000, and I have not tried any other products yet. I hope you can experiment more and there is

The environment is AIX 6.1, and DB2 9.7.0.7 first checks whether the db2 master process exists.Ps-ef | grep db2sysIf notDb2startOpen the database backup media as a cold backup data source and cd it to the directory where the media is located:Cd/home/

NoSQL databases: data consistency, nosql Database ConsistencyNoSQL Database: Data ConsistencyRead consistency High ConsistencyAccess any node in the cluster at any time, and the data obtained is consistent; User consistency is consistent with the

Http://www.infoq.com/cn/news/2014/01/nosql-vs-rdbms Naresh Kumar is a software engineer and enthusiastic blogger who is very interested in programming and new things and is very happy to share technical research results with other developers and

Use of the ios CoreData framework, add, delete, modify, and query context data, association between tables, 1-to-many, 1-to-1, predicate query, multi-table join, ioscoredata Here is just code, because the effect of inserting images into a blog is

The server Load balancer of the Oracle RAC server distributes new connection requests to the node with the smallest load based on the number of connection loads of each node in the RAC. When the database is running, the PMON process of each node in

ORACLE Installation./runInstaller reports "You are attempting to install 64-bit Oracle on a 32-bit operating system., yuminstalloracle Prepare to install the oracle database, see: http://blog.csdn.net/mchdba/article/details/43086037 1. solution (1):

ORACLE-006: Remove and stop jobs, oracle006 remove jobs Generally, you can use SQL to delete or stop a job. Remove JOB: remove Stop JOB: broken First pass Select * from user_jobs; Find the job id, and then call Dbms_job.broken or

Introduction to PL/SQL program design and plsql Program DesignZookeeper ① PL/SQL program design overview PL/SQL is an advanced database programming language used to access ORACLE databases in various environments. Because the language is integrated

Php PDO connects to mysql and phppdomysql Recently, a new environment has been installed in linux, php5.6 + mysql5.5 + nginx. Then, an error occurs when you use the original mysql connection to the database. The reason is that the database

Data Analysis System DIY2/3: Local 64-bit WIN7 + dev c ++ compiler for VMware CentOS7 + MariaDB, diy2win7 Three tasks to be completed in DIY data analysis system. 1. Use VMware to install 64-bit CentOS. The database server can use the built-in

2 logging3 datafile '/opt/oracle/oradata/bisal/test_data_01.dbf'4 size 10 M5 autoextend on6 next 10 m maxsize 2000 m7 extent management local;Tablespace created. Total 1.5 GB-Rw-r ----- 1 oracle oinstall 11 M Sep 27 22: 56 test_data_01.dbf 2

After the installation is complete, log on to the sample database and toolsdb and find the error: db2 => connect to sample   SQL1031N The database directory cannot be found on the indicated file system.   db2 => connect to toolsdb   SQL103