Database Administrator

In vim editing mode, the number of lines "sudo vi/etc/vim/vimrc" can be displayed. Add "set nu" to the opened file and save the settings and exit. Use: "vi. bash_history" to view the previously entered commands When compiling the database program

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

Notes for configuring data-source in the struts-config.xml:Name: data-sourceDescription: The data-source element defines specific data source attributes:@ Key: when multiple data sources need to be configured, it is equivalent to the data source

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)

Test environment: OS: RedHat 5.5 DB: Oracle11g Logminer is integrated with oracle as a related log analysis tool. We can use this tool to clearly analyze the changes of all things in related logs and archive logs, in addition, you can accurately

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

JDK is often installed and some configuration files are edited when you install a web server in Linux. how to configure the configuration? Let's start the basic operations: 1. Install JDK: (1) download the jdk-1_5_0_04-linux-i586-rpm.bin from SUN,

In this DocumentGoalSolution Applies: Oracle Server-Enterprise Edition-Version: 9.2.0.6.0Information in this document applies to any platform. Goal In this note, we will help Database Administrators with answers to two common questions:How can I

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 @

Environment Introduction:Operating system version: RHEL5.4 32-bitOracle version: 10.2.0.1 32-bitOracle_SID: orclThe operating system of the source server and target server is consistent with that of oracle. Source server: 192.168.227.20Target Server:

Automatic Storage Management Background (ASMB) process: the ASMB process runs in the database instance that uses ASM. It is responsible for communicating with the management and storage ASM instance, providing updated statistics to the ASM instance,

1. Log On As root and enter the command sudo gedit/etc/mysql/my. cnf on the terminal in the open file.Find the [client] and add it belowDefault-character-set = utf8Find [mysqld_safe] and add it belowDefault-character-set = utf8Find [mysqld] and add

Use ctrl + c to exit the current status output mode. Run the following command: expdp userid/password attach = job_name to connect to the currently running import/export task. You can use job_name to specify the task name. 1. add_file = test _ % U.

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. 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

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