Database Administrator

I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and

The management framework includes: database instance, listener, and Management Interface (database control, management proxy, which is used by Grid control)Manage database control (Oracle provides a Database control console for databases that are

MongoDB document database provides the master-slave replication mode. In fact, the master-slave replication configuration of MongoDB is very simple, that is, when the MongoDB service process is started, specify -- master, -- slave, and one is

Oracle 11g has added the system information backup and recovery functions at the system level, user level, and table level! When we collect statistics on oracle system objects, we can useDbms_stats.export _ (database/schema/table) _ stats export

Subroutine introduction: •NamedPL/SQLBlock,Acceptable parameters,Can be called. •Subroutine type Process:Used to perform an operation Function:Used to execute an operation and return values •Standard-basedPL/SQLBlock

This article is a by-product study of Mongodb distributed data storage. Through the relevant steps in this article, we can distribute data in a large table to several mongo servers. In MongoDB 1.6, the auto-sharding function is basically stable and

The decode () function is one of the powerful functions of Oracle PL/SQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. The DECODE function is one of the powerful functions of

1Decompress the installation package # Gunzip v9.7_linuxia32_server.tar.gz # Tar-xvf v9.7_linuxia32_server.tar 2, Enter the decompressed file directory, and execute the installation:(We choose to install it manually) Note:DB2_installFor manual

Oracle has the following two tables: update the val value of the row with the same id value in Table tab1 and that in Table tab2 to the val value in table 2.Select * from tab1; Select * from tab2 The most common mistake is: update tab1 set val = (

I. Fault symptom: SQL> conn system/OracleERROR:ORA-28000: the account is locked Warning: You are no longer connected to ORACLE.SQL> Ii. Cause Analysis:Unable to log on because the system is locked Log on to the operating system using the sys user or

1. Use the view to test the database cache size: If your enterprise opens a new business and develops a new application for this purpose, a new database is required as the background. You are responsible for regulating this new database. So how do

Preface Every DBA in the Process of database management should inevitably encounter a variety of errors (ORA-1547, ORA-904, ORA-1578 ......). Some errors are often called "classic errors" by Oracle DBAs due to frequent and complex causes ". The ORA-3

RedHat version: 6.2 Mysql version: mysql-5.5.19 Installation Package file name: mysql-5.5.19-linux2.6-x86_64.tar.gz 1. installation steps: Download the mysql-5.5.19-linux2.6-i686.tar.gz package from the official network. Decompress this package and

In Linux, allow external ip addresses to access your MySQL database: 1: Set the mysql configuration file /Etc/mysql/my. cnf Find bind-address = 127.0.0.1 and comment it out; // This will no longer allow local access only; Restart mysql:/etc/init.

Oracle SQL Developer 3.1.07.42 is installed in Linux Mint 12 (see). It feels good to connect Oracle, Mysql, and SqlServer ......., but there has always been a problem, that is, when the mouse is clicked, the mouse will be offset. Specifically, the

Perform Oracle operations with DML in the following internal order:1. The corresponding transaction is allocated a rollback segment (undo segment ).2. After a rollback segment is allocated, create the transaction table slot (transaction table slot)

I. mySQL Database Backup 1. create database xscj character set utf8 COLLATE utf8_general_ci; 2. create table student (Sno int (10) not null comment 'student ID ', Sname varchar (16) not null comment 'name', Ssex char (2) not null comment 'gender',

Brief description of PostgreSQL database operations PostgreSQL database version Psql -- versionPsql (PostgreSQL) 9.1.3 I. Database Backup 1. Backup database structure Su-postgresPg_dump-Fc-s-f testdbschema. SQL testdb 2. Back up database

In Oracle databases, we often need to manually analyze tables and indexes, as well as all tables and indexes in a certain mode. Oracle provides two Analysis Methods: The dbms_stats package and the analyze command. These are our practical methods in

Installation environment Linux Server: SUSE10 sp2 64-bit Oracle Server: Oracle11gR2 64-bitSystem Requirements Requirements for installing Oracle in Linux System Requirements Description Memory Physical memory must be