Database Administrator

Cold backup is to copy the database-related files. It can only perform restoration operations and cannot perform restoration operations. Log on to the database, find the path for storing data files, control files, and log files, close the database,

Sqlldr loads data into the database. The data in the External table is based on the operating system file, and the real data is not saved to the database, which is in the operating system file. Therefore, the data in the External table can only be

I. Official Website description Http://download.Oracle.com/docs/cd/E11882_01/server.112/e26088/functions088.htm#SQLRF00658 Purpose The LENGTH functionsreturn the length of char. LENGTH calculates length usingcharacters as defined by the input

No matter when the process or user calls back to modify the data in the database, Oracle saves it (the data in the database) as undo data as the old value that has been modified before. This design provides many benefits for database users. Allow

[Root @ localhost Server] # rpm-ivp binutils-2.17.50.0.6-14.el5.i386.rpm Warning: binutils-2.17.50.0.6-14.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186 Preparing packages for installation... Package binutils-2.17.50.0.6-14.el5.i386

1. Select the most efficient table name order The SQL parser processes the table names in the FROM clause in the order FROM right to left. If the FROM clause contains multiple tables, you must select a table with the least number of records as the

First look at the table content Select name, pass from t1; 2. Method 1: Use the decode Function Select name, decode (pass, 'passs111', 'pass1', 'pass222', 'pass1', '', 'Password') from t1; Note: If you do not list the possible conditions in the

One of the biggest challenges for developing multi-user database applications is to strive for the maximum concurrent access while ensuring that each user can read and modify data in a consistent manner. The maximum number of concurrent accesses

Open Database flashback1. Check whether flashback is enabled for a database. There are two simple methods:(1) directly query the databaseSQL> select name, log_mode, flashback_on from v $ database; NAME LOG_MODE FLASHBACK_ON---------------------------

When I was installing OracleXE for developer Demon today, there was a prompt: Destination Folder: D: \ oraclexe \ PortFor 'Oracle Database Listener'1521 PortFor 'Oracle Services for Microsoft Transaction Server'2030 PortForHTTP Listener:

Oracle Parsing process (SQL Parsing Flow digoal) When a user sends an SQL statement to the oracle database, runs the anonymous statement, or runs the SQL statement deployed in the database, the database works according to a certain working mechanism

Create a connection >>> Import pymongo>>> Connection = pymongo. Connection ('localhost', 27017)Switch Database >>> Db = connection. test_databaseGet collection >>> Collection = db. test_collectionDb and collection are created in a delayed manner.

1. modify the configuration of remote linux machines The configuration in the vim/etc/sysconfig/i18n file is as follows:LANG = "zh_CN.GBK" SUPPORTED = "zh_CN.UTF-8: zh_CN: zh: zh_CN.GBK"SYSFONT = "latarcyrheb-sun16" 2. Modify the Oracle environment

In projects, serial numbers are often generated based on the year, month, and day rules. A simple stored procedure can be expanded as needed. I. Serial number Storage table -- Create tableCreate table SYS_GENKEY(DATESTR VARCHAR2 (50 ),Maxcount

Exp_p.sh #! /Bin/sh #$1 generate the storage path of the dmp File If [-d "$1"]; then Echo "" $1 "exist" # The user name/password generated file name is automatically generated based on the date of the day, for example, 20111128.dmp Exp

Fault symptom: 15:45:29WARNING OGG-01004Oracle GoldenGate Delivery for Oracle, rora_001.prm:Aborted grouped transaction on 'realestate. JZWFCMS ', Database error 1403 ().15:45:29WARNING OGG-01003Oracle GoldenGate Delivery for Oracle,

When installing Oralce on Linux, you must first check whether one pair of rpm is installed. If you check them one by one each time, it will be very troublesome, so a script is simplified. This script takes only three steps: 1) Save the following

The Oracle user must perform operations on the Oracle server. The procedure is as follows: 1. Retrieve the font file simsun. ttc from windows 2. Create the fallback folder in the $ ORACLE_HOME/jdk/jre/lib/fonts directory. Command: mkdir fallback

AdditionSelect sysdate, add_months (sysdate, 12) from dual; -- add 1 yearSelect sysdate, add_months (sysdate, 1) from dual; -- add JanuarySelect sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual;-- Add 1 weekSelect sysdate, to_char

Oracle Database REAN recovery data file recovery is what we will introduce in this article. We know that apart from the system tablespace data file (mount, other data files can be restored in the open (mount) state. restoring data files in the open