Database Administrator

The Physical Data Model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be detailed on the basis of the

1. After logging on to Oracle, enter the following command: [Oracle @ localhost ~] $ Vi. bash_profile 2. Add from # huzia. #. Bash_profile # Get the aliases and functions If [-f ~ /. Bashrc]; then .~ /. Bashrc Fi # User specific

Impact of/dev/shm on Oracle 11g: ORACLE introduced an Automatic Memory Management feature from the 11g version. This feature requires more shared Memory (/dev/shm ), therefore, if you decide to apply this feature, make sure that the shared memory is

Stored Procedures, functions, triggers, tables, etc. In PL/SQL: Export: Tool --> Export user object --> select multiple user objects to be exported, and select the path of the output script file (SQL file) --> export. A. SQL script file is

Install Mysql on both servers in the/usr/local/mysql directory (the installation steps are omitted. Refer to the relevant documentation ), the IP addresses of the two servers are 192.168.0.1 and 192.168.0.2. We use 192.168.0.1 as the master database

Principle of a master-slave ConfigurationMysql Replication is an asynchronous Replication process, from one mysql instance (Master) to another mysql instance (Slave ), the entire replication process between the master and slave is mainly completed

1Method1 [Oracle @ rhfour test] $Strings control01.ctl 2Method2 Connected: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production With the Partitioning, OLAP and Data Mining options   SQL>Alter database backup controlfile to trace as '

To configure automatic archiving for the database (if you configure Oracle installation to use PFILE), add the following log parameter lines to the INIT (SID). ORA file in the $ ORACLE_HOME/dbs directory: LOG_ARCHIVE_START = TRUE LOG_ARCHIVE_DEST =

Oracle single table stream replication is completed. Due to the many steps of oracle stream operations, many problems have been encountered before, Failed because I did not clarify my thinking or did not understand this. For important tables, stream

UPDATE SMS_PROVINCE set provincename = REPLACE (PROVINCENAME, CHAR (10), ''), CHAR (13 ),''); Environment: RHEL5 + MySQL Solution: UPDATE tablename SET field = REPLACE (field, CHAR (10), "), CHAR (13 ),"); Char (10): line feed Char (13): Carriage

Hibernate provides many methods for object operations. This article briefly introduces the use and comparison of these methods. Before describing the methods, describe the three states of objects in hibernate: transient, persistent,

1. there is a data export tool under the bin directory of the mongodb installation directory: Export export.exe. We can open a command window, switch to this directory, and execute export, you can see many parameter descriptions for using this tool.

In some cases, for example, you only want to install some client software to perform basic operations or tests on connecting to the database. To achieve the connection, you need to install the Oracle client. Therefore, oracle provides a dedicated

The MySQL innodb Storage engine uses the same row lock mechanism as Oracle. The following experiment shows how to view the row locks in the system. The following is the test process:Session 1: update records Mysql> set autocommit = off; Query OK, 0

Result: a stored procedure is written under a user in a database. During the stored procedure, DBLINK is used to connect to another database and the number of users in this database is obtained, insert a table in the current database. 2. steps: 1.

I. Error code: ORA-12547Symptoms:(1) Oracle listening and Service Startup are normal and no error is reported(2) Check the log without any exception information(3) The local commands on the server can connect to oracle and execute query commands.(4)

I. Test 1. download the latest sqlite source code sqlite-autoconf-3070500.tar.gz from the sqlite website http://sqlite.org/download.html. The latest version is 3.7.5. 2. decompress the source code, enter the source code folder mkdir _ install,

1. DESCRIBE command The usage is as follows: SQL> describe nchar_tst (nchar_tst indicates the table name) The result is as follows: Is the name empty? Type-----------------------------------------------------------------------------Name nchar

What is a function? Generally speaking, as long as it can receive input, process input and generate output, it can be called a function. For example, a cow is a function, and it eats grass (input) and milk (output) A function is a program design

Regular Expression Function (10 Gb introduced)Regexp_like ('s ', 'Re', 'O ')S string or column expression to be searchedRegEx contentO parameter (optional)Idle> select ename from emp where regexp_like (ename,'s