Database Administrator

Backup policy: Sunday level 0Monday, second, fourth, fifth, sixth, Grade 2Level 1 on Wednesday -- Create a local management path Mkdir-p/dinglp/ora_managed/backupMkdir-p/dinglp/ora_managed/backupMkdir-p/dinglp/ora_managed/backup/exportMkdir-p/dinglp/

RHEL5.5 Software Package requirements: The following packages (or later versions) must be installed: Binutils-2.17.50.0.6Compat-libstdc ++-33-3.2.3Compat-libstdc ++-33-3.2.3 (32 bit)Elfutils-libelf-0.125Elfutils-libelf-devel-0.125Gcc-4.1.2Gcc-c ++-4.

The Oracle Database IMP/EXP in Linux is a beginner. Yesterday, when I was in the IMP oracle database, I always prompted that IMP-00002 cannot open *. dmp files in the specified path. No answer is found for the network query. Ask the ERP vendor today

Environment: Red Hat Linux AS 4 Nahant x86 + Oracle 10.2.0.1 x86This document records the commands used to start and close Oracle 10 Gb database and related files.The three steps for Oracle Database 10g startup are as follows: 1. Create and start

Sqlplus/as sysdba > Select total. tablespace_name, round (total. MB, 2) as Total_MB, round (total. MB-free.MB, 2) as Used_MB, round (1-free.MB/total. MB) * 100, 2) as Used_Pct from (select tablespace_name, sum (bytes)/1024/1024 as MB from

1. the mysql-client package needs to be installed on the client. The library files we need after installation are complete; 2. Install the mysql-dev package. After installation, we need the mysql. h file; 3. As a client, you only need to install

An exception is an exception that has been defined in pl/SQL and given the Exception name. They are all placed in the standard package that comes with pl/SQL, so that pl/SQL programmers do not need to define them again. There are 21 predefined

The first time I met Oracle, I sorted out some simple and practical solutions. Confirm orcale Recognition-it is a annotator, not recognized # Length () is a string length function, not len () Table Dual: system table, with only one option

[Problem description]1. garbled characters are displayed for file names containing Chinese Characters in Linux;2. Use the vi editor to view Chinese characters with garbled characters;3. sqlplus enters the database to view Chinese characters with

How to Use the find_in_set function of MySQL This is often the case when designing databases, for example: There is a type field in the Document Table, which stores the article type, including 1 headlines, 2 recommendations, 3 hotspots, and 4

When we do not know the specific data, it is unknown. We can use null. We call it null. The column length of a table containing null values in Oracle is zero. Oracle allows null data types. In addition to the primary key field pk, the restriction

1. Create Or Replace FunctionPostgresql (p_tnameVarchar2, P_colnameVarchar2)ReturnClobIsV_tmpVarchar2(200);V_result clob;V_cum sys_refcursor;BeginOpenV_cumFor 'Select' |P_colname| 'From' |P_tname;LoopFetchV_cumIntoV_tmp;Exit

One way to access MySQL using Python in Linux is to use the MySQLdb module. The following describes how to install MySQLdb in Linux. (1) download MySQLdb Download the latest MySQLdb, http://sourceforge.net/projects/mysql-python/ from SourceForge.net,

Due to development needs, MySQL 5.5.9 needs to be installed and installed now. There are always errors when rpm is used, and there are still a lot of troubles related to the issue. In addition, no Binary Package is found, I had to find the source

Slave Oracle Storage Level Architecture, Oracle A database consists of one or more tablespaces. Tablespace : A logical storage container, which contains segments and consists of one or more data files. The relationship between segments and data

Today in the deletion of a large table column, accidentally DBA restart DB, and then execute the query, it reported the ORA-12986 error, first come to understand this error: ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP

No time to check the same configuration of the Oracle database on a daily basis. Later, it was discovered that the master database did not synchronize archiving logs to the slave database because the slave database was not enabled after power

One of the daily work of the system administrator is to upgrade the service, add a patch for the service or upgrade some fancy functions. In early 2013, the latest MySQL 5.6 was released with the goal of providing better performance and scalability.

1. Preface Recently, due to project requirements, the employee's working group needs to be returned to the front-end. However, in the database, the employee's working group Id is included in a field (separated by commas ), this does not meet the

For the heap table in Oracle, we can obtain the ROWID value of the corresponding row record through the ROWID pseudo column built in oracle (note that this ROWID is only a pseudo column, the column does not exist in the actual block ). Then we can