Database Administrator

RMAN uses backup to transmit tablespaces The method for creating a tablespace set in the Oracle Database Management Manual requires that the tablespace transmitted during the execution of tablespace transfer should be opened in read-only mode. In

Users who query database objects in Oracle Users who query database objects in Oracle -- Query tables and views of a userSELECT TABLE_NAME, OWNER, TABLE_TYPE FROM ALL_TAB_COMMENTS where owner = 'vass '; -- Query views of a userSELECT VIEW_NAME,

Restructuring of the vb.net data center charging system-Summary (1) combing the business and table structure, vb.net Charging System The Charging System of the IDC room has been in progress for some time. I have received a notification two days ago

SQL Server INSTEAD OF UPDATE view trigger problem, sqlserverinstead An error occurs when the system's instead of update view trigger is associated with table UPDATE: Message 414, level 16, state 1, 1st rowsUPDATE is not allowed, because this

MYSQL master-slave replication builds the entire process-explore key parameters that cannot be synchronized in real time, mysql master-slave Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/45873859 1. master

Ios database sqlite-third-party framework FMDB, thread-safe transaction processing, sqlite-fmdb Import sqlite3 database and third-party framework FMDB // 1. Obtain the sandbox path NSString * path = [NSSearchPathForDirectoriesInDomains

Data room charging system-SqlHelper, charging system sqlhelper I have added a lot of ADO. NET basic knowledge, now it is time to seriously practice it. Next I will introduce the use of SqlHelper IN THE vb.net data center charging system, in the data

Data center fees-configuration files and data center configuration files After knocking on the Layer 3, I finally adapted to a model and changed the Layer 7. With the habit of the layer 3 and the enthusiasm of the layer 7, I began to think. So the

Data structure, data structure and AlgorithmStack 1 stack ConceptStack: a linear table that is limited to insert and delete operations at one end of the table. It is also known as the Last In First Out (LIFO) or the First In First Out (First In Last

Simulate rm for cold backup and rm for cold backupBackup recovery has always been a major concern for all relational databases. The following describes the Cold Standby database, simulates and destroys data files to restore the database, and

One of the oracle learning starter series, database development and history, one of the oracle Series   Oracle learning starter Series Database development and history   This oracle learning getting started series is based on some of my work notes,

MySQL study note _ 2_MySQL create a data table (on) and study note _ 2_mysqlCreate a data table (on) in MySQL) I. Create an SQL statement model for a data table [weak type] CREATETABLE [if not exists] Table Name ( Type of field name 1 column

Oracle Database cursor case and source code, oracle cursor 1. cursor ConceptCursor is a data buffer provided by the system for users to store the execution results of SQL statements. Each cursor area has a name. You can use SQL statements to obtain

MHA masterha_check_repl detection process, gocheck paper detection Whether the MHA deployment and configuration are OK. We can use the masterha_check_ssh and masterha_check_repl scripts provided by MHA to check whether the MHA deployment and

Use PowerDesigner 15 to reverse engineer existing databases and powerdesigner15 1. Start PD 2. Menu: Database-> Congfigure Connections the Congfigure Data Connections dialog box is displayed. Click Add Data source. The create Data source dialog box

The role of temp tablespace and the role of temp tablespace The role of temp tablespace: Temp tablespace is mainly used for sorting operations [such as creating indexes, order by and group by, distinct, union/intersect/minus/, sort-merge, join,

Simple query of oracle client bits 32-bit or 64-bit, oracle32bitDirectory Directory Linux platform Windows Platform Linux platform Go to the bin directory of the client installation directory (CLIENT_HOME ). $ Cd

Records the SQL statements executed by MySQL, and records the SQL statements executed by MySQL. Comparing Oracle functions to learning Mysql will always discover highlights Using the log mining skill in Oracle, you can find all records that have

Four major features of transactions: atomicity, consistency, isolation and durability (ACID), four major acid 1. Transactions Definition: a transaction is a sequence of operations. These operations are either executed or not executed. It is an

MySQL database optimization summary, mysql database Summary I. Considerations for MySQL database Optimization 1. Database Design (rational table design) Three Paradigm (Standard Model) The three paradigms include: Paradigm 1: 1NF is a constraint on