Database Administrator

Error in building aix rac -- Default Gateway not configured Environment:Operating System: AIX 5300-09Cluster software: CRS 10.2.0.1Database: Oracle 10.2.0.1Fault symptom:The following error occurs when running the root. sh script while building the

Use of DML (Database operating language) in SQL 1. Insert statement:INSERT [INTO] table [(column1, column2, column3,...)] VALUES (value1, value2, value3 ,...);Example: insert into user VALUES (NULL, 'test', '20140901 ');Example: insert into user

Introduction to PostgreSQL user roles and their attributes 1. Users created by create role do not carry the LOGIN attribute by default, while users created by create user have the LOGIN attribute by default, as shown below: Postgres= # Create role

ORA-01157 in Oracle Database: unable to identify/lock data files Environment: SLES 11 sp1 + RAC 11.2.0.3.7 I am about to take a vacation. I checked the database and found that node 2 of the billable billingdb database has the following error:Fri Apr

How to locate and kill bad MySQL queries? Sometimes, the complexity of relational database systems will confuse you, but fortunately, using MySQL tools to manage queries can avoid these complexities. In this tutorial, I will show you how to find and

MySQL Character Set inheritance relationship Verification (1) When a database is created, a character set that is not specified will inherit the server character set.Server characterset: utf8Db characterset: latin1 Mysql> show global variables like '

[RMAN] use duplicate to copy the database locally Task: the same host uses RMAN duplicate to copy the database. In the linux operating system, there is a set of running database aux after enmoedu replication. Tutorial steps: 1. master database RMAN

The correct installation of oracle11g plsql under the win7-64bit, oracle11gplsql I have installed the Oracle 11g Database Service on my PC. I cannot connect to the database through PL/SQL because PLSQL does not have a 64-bit version, an error is

Use of association, use of association Why is association unable to associate information, only Id: Is there a problem with writing like this? How to Use File Association Manager You can specify to always

Oracle fga audit has these features, oraclefga audit featuresFga audit has the following features:This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/384090571. select * from table_

Hard Parse & Soft Parse, hardparse Each DDL execution requires hard parsing. SQL parsing process Oracle will take the following steps to process this SQL statement: 1. syntax check: check whether the spelling of this SQL statement is correct. 2.

Real-time data warehouse and data warehouseShare an example of a real-time data warehouse.The customer is a municipal Tobacco Company and needs to analyze the cigarette sales data in real time. About 0.1 million pieces of data are collected every

Buffer pool and shared pool (1), buffershared [In-depth analysis-eygle] Study Notes 1.1 buffer pool Principle Buffer Cache is an important part of Oracle SGA. Generally, data access and modification must be completed through BufferCache.When a

FAQs about Oracle Installation-1, oracle-1 Installing Oracle may be a simple task for some people, but the installation process contains a wealth of knowledge points, especially on the Linux platform, we may encounter a variety of strange problems.

Why MySql transactions cannot be rolled back When using MySQL, if you find that the transaction cannot be rolled back, but the Hibernate, Spring, JDBC and other configurations do not have obvious problems, don't worry, first check whether the table

MySQL hash partition (4), mysqlhash Partition For details, see MySQL partition (1) Example: Here is my personal learning Summary-> details --> if you have any questions, please come and talk about it. MYSQL hash decryption Root:

MySQL inserts data, mysql inserts data INSERT data Insert complete rows Insert Part of a row Insert multiple rows Insert query results Insert the complete row and check the original customer list first: INSERT a row: insert into

Transplantation of sqlcipher and sqlcipher I. Download Code Sqlcipher depends on the openssl library. First download openssl: [fulinux@ubuntu ~]$ git clone https://github.com/openssl/openssl.git Download sqlcipher: Site: Workshop [fulinux@ubuntu ~]

Dbca database creation, configuration listening, data import (CentOS5.6 + Oracle10G), dbcaoracle10g Dbca database creation, configuration listening, and data import (CentOS5.6 + Oracle10G) **************************************** *******************

Returns the result set of the ORACLE character split function. ORACLE does not support direct return of table type like MSSQL. Therefore, you must first create a custom type. This statement uses a Nested Table ). -- Nested TableCREATE or replace