Database Administrator

Basic Introduction to Oracle 12C PDB Maintenance Basic usage: Run the command before 11G. Conn/as sysdba; Create user test identifed by test; ORA-65096: The public user name or role name is invalid. Check the official document and find that "to

Oracle DML Error Log notes DML error log is an error log function introduced by Oracle 10gR2 similar to SQL * Loader. The basic principle is to transfer any records that may cause statement failure to an error log table. The specific usage is as

Troubleshooting of MySQL cluster architecture and configuration problems First, let's talk about the advantages and disadvantages of MySQL. Advantages Solving single point of failure Automatic data redundancy The disadvantage is that maintenance

DBMS_METADATE.GET_DDL, dbmsmetadata You can use the package dbms_metadata.get_ddl to view a table or table space DDL. Detailed parameters of the get_ddl function in the dbms_metadata Package: The GET_DDL function returns the DDL statement of the

Paradigm Theory, database Paradigm Theory Currently, relational databases have six paradigms: 1NF, 2NF, 3NF, 4nf, and 5NF ), the sixth paradigm (6NF ). The paradigm that meets the minimum requirements is the first paradigm. The second paradigm that

MongoDB time zone and mongodb Time Zone For work reasons, I recently worked on a mongoDB java project. The time in the project is found to be faulty. Each time the data is saved, it will be less than 8 hours. Solution Add annotation before

2015 Xin Xing MySQL tutorial Spring edition fourth optimization modeling, Xin Xing mysql After some time, the fourth tutorial of the xinxing MySQL tutorial in 2015 was finally completed. It was positioned as modeling optimization. For example,

[ORACLE] analyzes 23 oracle sessions and performance statements, and 23 oracle session statements.**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**********

Shang Silicon Valley-mybatis-(one-to-one Association), Silicon Valley-mybatis- Demand: Query Class information by class id (with Teacher Information) Project Structure: Create tables and data: CREATE TABLE teacher(t_id INT PRIMARY KEY

GOLDENGATE installation and Data Replication flow setup configuration _ excluding DDL extraction version and goldengateddl GOLDENGATE installation and Data Replication flow configuration (The source database is an instance and supports ASM,

Oracle uses a cursor to query a string that combines the names of all fields in a specified data table. oracle cursor Application Scenario: refer to the Code for querying all field names of a data table on the Internet, and use a cursor to generate

[Translated from mos] The buffer memory parameter is used to adjust the performance of rman ., MosrmanUse the buffer memory parameter to adjust the performance of rman.This article is translated from the mos article: RMAN Performance Tuning Using

Student Information Management in Mysql c api, mysqlapiZookeeper With the embedded MySQL Server library, you can use MySQL servers with all the features in client applications. The main advantage is that it increases the speed and simplifies the

SQL To LinQ do you know ?, Sqllinq You should have used the linQ to SQL tool LinQPad when learning LinQ. It was used at the beginning and is not very familiar with it. What should I do if it involves multi-table queries and does not write a LinQ

MySQL5.5.21 tutorial 2, mysql5.5.21 tutorial Now let's take a look at the basic table operations! It is mainly to create tables and basic constraints. We will continue to explain the index issue later! # Columns-also known as attribute columns.

Common oracle maintenance and oracle maintenance at work Http://blog.csdn.net/lili72 Background: due to historical reasons, some of the company's businesses are still using oracle. If something goes wrong, it is very troublesome. Since mysql, hive,

Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2), connectmysql. sock When mysql is installed in linux, the following error occurs: Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2) This error occurs,

Oracle 11 password is set to never expire, oracle never expireFollow these steps:1. Check the user's proifle, which is generally default:SQL> SELECT username, PROFILE FROM dba_users;2. view the password validity period settings of the specified

EMCA fails with error "ORA-01017: invalid username/password; logon denied", emcaora-01017 Creation of dbcontrol repository fails when execute  $ Emca-config dbcontrol-repos create With error:Database connection through listener failed. Fix the error

Use of the padding function lpad/rpad in oracle, lpadrpadLpad 1. Syntax Lpad (string, pad_length, [pad_str])2. ExplanationThis function indicates filling the specified character to the specified length from the left side of the string. The space of