Database Administrator

Korean encoding can be stored using UTF-8 or dedicated euc-kr encoding. In today's work, we need to transfer data from a Korean website to a local device for testing, Then it is transferred to the database of another server. The mysql import and

Recently, we have been porting SQL to Oracle. Since Oracle does not have the same Identity column as in SQL, we have encountered a lot of trouble, recently I encountered a stored procedure for deleting data based on the values of the

1. If the DDL syntax is correct, implicit commit will occur even if the execution fails: Duzz $ scott @ orcl> create table t1 as select * from dept; Table created. Elapsed: 00:00:00. 03 Duzz $ scott @ orcl> update t1 set loc = 'xx' where deptno = 10;

ROLLUP will gradually remove a field on the right from the right to the left Based on the field following group by, and gradually sum up, CUBE sums all the combinations of fields after group. CUBE eg1: SELECT department_id, job_id, SUM (salary)

MTBF: Mean-Time-Between-Failures average Time Between two FailuresMTTR: Mean-Time-To-Recover average fault recovery Time Fault Type:1. faults caused by SQL expressionsBUG, invalid data, permission exceeded, quota limit2. User process

Running Environment CentOS 5.6 Hadoop hive Sqoop is a tool developed by clouder for hadoop technology support to import and export data between relational databases, hdfs, and hive. Read more: Sqoop configuration and installation 1. Install sqoop

How does an Oracle service process user process requests? The server process mainly completes the following seven tasks in the process of completing the user process request: 0. SQL statement Parsing1. Read data blocks into db buffer2. log recording3

This chapter describes how to configure and manage the Oracle EBS warning system. It is convenient and timely for users or the system to operate databases. Next we will talk about the procedure: 1. Manage the alert system --> System --> OptionThe

Object permission test:In the initial state, neither user2 nor user3 has the object permission of user1.t1.Table t1 exists in user1:Duzz $ user1 @ orcl> select * from t1;C1----------1111Elapsed: 00:00:00. 00User2 cannot query user1.t1:Duzz $ user2 @

Oracle log mining (LogMnr) ① Set the utl_file_dir path in the parameter file ② Restart ③ Create directory file and use execute dbms_logmnr_d.build () ④ Add a log file and use dbms_logmnr.add_logfile Or delete the log file, use dbms_logmnr.removefile

ASH usageSQL>@? /Rdbms/admin/ashrpt. SQL Current Instance~~~~~~~~~~~~~~~~DB Id DB Name Inst Num Instance-------------------------------------------450641661 SUBSDB 1 subsdb Specify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Enter 'html' for an html

Here we will introduce in detail how to compile and install mysql with a non-root Account: 1. Create a mysql account with rootUseradd-m mysql 2. Download mysql-5.1.58.tar.gz from the official website and put it in/home/mysql/software. Unzip the

1. What is bitmap index? You only need to store the key value in the index segment, instead of rowid. Each bit in a bitmap index is equivalent to a row that may have this key. 2. Benefits of creating a bitmap Index I. It can save storage index space.

MySQL partition Overview: Allows you to allocate multiple parts of a single table across file systems based on rules that can be set to any size. In fact, different parts of a table are stored as separate tables in different locations. The

[Root @ Oracle9i mysql] # cp support-files/mysql. server/etc/init. d/mysql[Root @ oracle9i mysql] # chmod + x/etc/init. d/mysql[Root @ oracle9i etc] # chkconfig -- list mysqlService mysql supports chkconfig, but is not referenced in any runlevel

1. Configure link information Open PowerDesigner and click Database ---> Configure Connections in the main menu to select Connection Profiles 2. Add a data source. Click Add DataSource in. 3. Click Test Connection to Test whether the

Environment Description: This environment consists of two mysql Databases and heartbeat. One ip address is 192.168.10.197, the other is 192.168.10.198, and the other is 192.168.10.200. Note: heartbeat itself cannot automatically switch between

Check whether the Oracle database is in archive Mode1. select name, log_mode from v $ database;NAME LOG_MODE------------------------------------------ QUERY NOARCHIVELOG 2. Use the archive log list Command Database log mode No Archive Mode Automatic

1. Install related software packages The list is as follows: Binutils-2.15.92.0.2-13.EL4Compat-db-4.1.25-9Compat-libstdc ++-296-2.96-132.7.2Control-center-2.8.0-12Gcc-3.4.3-22.1.EL4Gcc-c

This series of articles details the process of adding 3rd rac nodes on the basis of two existing rac nodes, without any impact on the use of rac during this period, the operating system of the rac node is CentOS4.8 64-bit, and the database version