Database Administrator

To view the client information (mainly IP addresses) connecting to the database, you can use the v $ session view, which contains several fields related to the client information: OSUSER VARCHAR2 (30) Operating system client user name

Impdp import data, ORA-39082 ORA-39083 error number, the object cannot compile after the import can be compiled object to try: alter view view_name compile; if the error: Use show errors to locate the source of the problem, whether it is a

To connect to mysql through the command window in cmd, you only need to input mysql-uroot-p123456 in the command line. The prompt "mysql is not an internal or external command" appears ". The solution is to add C: \ Program Files \ MySQL Server 5.6 \

[Oracle @ slave ~] $ Cat/etc/sysconfig/i18nLANG = "zh_CN.UTF-8"[Oracle @ slave ~] $ Echo $ LANGZh_CN.UTF-8[Oracle @ slave ~] $ Echo $ NLS_LANG [Oracle @ slave ~] $ Sqlplus/nolog SQL * Plus: Release 11.1.0.6.0-Production on Sat Oct 30 13:24:10

The Endeca product system contains a lot of content. Previously, we introduced the most ignored but important content of IAS. This article mainly introduces the installation process of the EndecaETL tool: 1. Install the EndecaETL client on the

The database design mainly describes the structure and design of some databases, mainly for all internal staff, internal departments, project teams, designated personnel of the company. The following is my document on database design. 1

The partition index is a global partition index and a local partition index, and a global non-partition index (that is, a common index) is added. A total of three types of indexes are added. The organizational structure and application scenarios of

I recently spent some time learning Redis and recorded the entire process for future study. What is Redis? on the official website, Redis is completely open-source and free. It complies with the BSD Protocol and is an advanced key-value persistence

I. Stored Procedure PurposeIt is used to execute an operation, named PL/SQL block, and can receive passed parameters and be called.Brief IntroductionNamed PL/SQL BlockAcceptable parametersCan be called repeatedlyUsed to perform an operationStored

Http://www.infoq.com/cn/news/2014/01/neo4j-2 Recently, Neo Technology released Neo4j 2.0 GA with a brand new graph browser, node label, an optional mode, and improved Cypher. The most noteworthy improvement of Neo4j 2.0 is the brand new browser UI,

After twists and turns, we finally successfully configured Oracle11GR2 ASM when the vmwarevm Redhat Enterprise Linux 6 has installed a single-node Oracle database 11G R2. The record process is as follows: Environment: VMWare Player 5.0.2 build-103176

1. -- case sensitiveSelect * from a where a = 'abcde' collate Chinese_PRC_CS_AI -- case sensitiveSelect * from a where a = 'abcde' collate Chinese_PRC_CI_AI -- case insensitive2. If you want to make all the storage tables on the server case

Maybe the first time I came into contact with select... into... from... and insert... select... many people may misunderstand that, on the surface, it is not that simple to query relevant information and add it to a table. Next, pig will introduce

The storage outline can be used to fix the SQL Execution Plan. The storage outline consists of a series of optimizer hints related to SQL statements. When the storage outline is available, oracle automatically generates an execution plan for the

1. Add FieldsAlter table student add age number (5 );2. Modify FieldsAlter table student modify age number (10 );Alter table table2 rename column result to result2;3. delete a fieldAlter table student drop column age;4. Clear table dataTruncate

I. DescriptionThe oracle exp/imp command is used to export/import databases; Data export: Exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp -- export database fully exp myname/mypassword@192.168.100.152/orcl file = d: \ my. dmp full

Wed Dec 18 08:25:58 2013***********************************************************************Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION:TNS for Linux: Version 11.2.0.1.0 - ProductionOracle Bequeath NT Protocol

1. ADO. NET Provider For SQLite.ADO. NET provider is provided by a company in Hong Kong (looks like). For the project address, see: http://sourceforge.net/projects/sqlite-dotnet22. encapsulate SQLite. NET and provide a simple operation help

A problem occurred on the contact marketing platform a few days ago. Ask a colleague to help solve the problem. The result is two days later and the problem is still not located.We still need to solve the problem near the Spring Festival. We have

Today, a buddy sent a request for help, saying that the master node was never synchronized. He sent an error message to the master node and found that the error message from the error log was not truncated to show slave status \ G ), however, when