Database Administrator

SetWholeKingdeeEAS DatabaseMove to another environment for development and testing: BackupOracle Database: (you can also PL-SQL through external tools) [Oracle @ rcno8 ~] $Sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010

If your machine already has an Oracle database, it is very simple. Navicat can be directly connected to Oracle. If it is not installed, Navicat will prompt you to install the Oracle client. If it is not necessary, do not install the Oracle client.

Due to development needs, I want to implement some common prompts. For example, the prompt message content is: "The XXX value YYY is incorrect. Please check and enter it again !", Then, the general information should be: "{0} value {1} is incorrect.

An error is reported when the software installation Progress reaches 87%. Error in invoking target 'client _ sharedlib 'of makefile '/U01/app/Oracle/product/10.2.0 /Db/network/lib/ins_net_client.mk '.

Oracle is used all the time, and the most recent task is to deploy and release the system. Migrating the database from the original oracle database to the DB2 database encountered some problems during the process, and I think it is necessary to

Oracle audit can be used to query the operations performed by a user on the database. After 10 Gb, it can be used to query specific SQL statements. The entire process of opening an account with the audit function: 1. show parameter audit. You can

Enable PHP OCI8 extension on LinuxTo add an Oracle connection to Linux, You need to recompile PHP.1. Download and install Apache Cd apache_1.3.31 ./Configure -- prefix =/usr/local/apache \ -- Enable-module = so \ -- Enable-shared = max \ --

#! /Bin/sh# The scripts is for RHEL5U1# Author is kevin# Date 2011-06-06 For I in libXp-1.0.0-8 openmotif-2.3.0-0.3.el5 compat-db-4.2.52-5.1 compat-gcc-34-3.4.6-4 compat-libf2c-34-3.4.6-4 compat-gcc-34-g77-3.4.6-4 compat-gcc-34-c ++-3.4.6-4

There are three main types of data changes in the database: insert data (Insert), Modify data (Update), Delete data (Delete). These operations are commonly used by developers. This chapter briefly introduces these operations. The main contents of

Linux has many good memory and IO Scheduling Mechanisms, but they are not suitable for all scenarios. One of the headaches for DBA Linux is that it does not avoid ing the address space allocated to MySQL to swap because MySQL is very important. For

The dataset data comes from the stored procedure.SQLThe statement must be compiled before execution. The stored procedure is compiled.SQLStatement. The application can be called directly when needed, so the efficiency is relatively high. Stored

Method 1: Use sqlplus 64-bit: [Oracle @ qs-wg-db2 ~] $ Sqlplus/as sysdba;   SQL * Plus: Release 10.2.0.5.0-Productionon Sun Sep 25 08:57:22 2011   Copyright (c) 1982,201 0, Oracle. All Rights Reserved.     Connected: Oracle Database 10g Enterprise

Business Process Model (BPM) is mainly used in the demand analysis stage. It describes Business logic and rules in detail from the perspective of Business personnel, the process, process, message, and collaboration protocols between one or more

I recently received an email saying that there is not enough storage space. It seems that the RAMN backup set occupies a large amount of storage space.Looking at these backup sets, there were actually two months ago. No wonder the storage space was

After Oracle11g is installed on disk D and oracle10.2.0.3. the error "perl58.dll" is not found when oracle11g is uninstalled on disk E. C: \ Users \ Liangwei>Set PERL5LIBPERL5LIB = E: \ oracle \ product \ 10.2.0 \ db_2 \ perl \ 5.8.3 \ lib \ MSWin32-

1. Detailed description of export tool parameters [Oracle @ linux exp] $ exp help = y Export: Release 10.2.0.4.0-ProductionOnWednesday, September 16, October 5 15:08:57, 2011 Copyright (c) 1982,200 7, Oracle.AllRights reserved. Enter

Learn how to extract useful things from the vast ocean; otherwise, you will be exhausted. To put it bluntly, we will start studying GoldenGate these days. Let's take a look at what Installation and Setup Guide says. System requirements and

1. Search for user tables SelectTable_name, num_rowsFromAll_tablesWhereOWNER ='Tiger' ANDTABLE_NAMELike '% Master' Order ByNum_rowsDesc 2. Search user table fields Select*FromUser_tab_columns WhereDATA_TYPE ='Char' AndDATA_LENGTH = 119

Oracle 11g has made some improvements in optimization. Oracle automates the following optimization: Redo Logfile Sizing Advisor-this feature recommends Redo the optimal size of log files to avoid excessive disk I/O caused by frequent checkpoints.

I. Some procedures 1. The master server operates in a continuous archiving mode, while the slave server reads data from the WAL file of the master server in a continuous recovery mode. 2. the archive process pcompetition is responsible for copying