Database Administrator

Oracle single quotes are always missing in the past. For future convenience, record them now SQL> select ''' | nvl (SQL _id, prev_ SQL _id) | ''' SQL _id, ',' | nvl (SQL _child_number, prev_child_number) SQL _child_number from v $ session where sid

I. First recognized Namespace Oracle uses namespace to manage the schema object name. For the definition of Namespace, no detailed definition is found in the official documentation. related information is found on the Internet: SchemaObject

Oracle all_parameters view create SQL  /* Formatted on 17:06:07 (QP5 v5.114.809.3010 )*/ Create view all_parameters AS SELECT I. ksppinm name, I. ksppdesc description, CV. ksppstvl VALUE, CV. ksppstdf isdefault, DECODE (BITAND (CV. ksppstvf, 7 ), 1,

1) STARTUPStartup open: the default parameter of STARTUP is OPEN. OPEN the database and allow access to the database. All files described in the control file of the current instance have been opened.Startup mount: MOUNT the database. only DBA is

The following are installed in CentOS5.6 and Yellow Dog Linux release 6.2 (Pyxis. The latest MySQL version 5.5.14 requires cmake compilation and installation.1 mysql 5.5.14 compilation and InstallationInstall the required system library filesYum

FirstGo to the Oracle official website to download the C language library file and header file URL as follows, select the corresponding Instant Client Version (I downloaded all zip packages without downloading the rpm package, the rpm package should

The index corresponding to a primary key becomes garbled. For SQL plus query: SQL> select INDEX_NAME, INDEX_TYPE, TABLE_NAME, UNIQUENESS from user_indexes where 2 table_name = 'oo _ OMS_USER '; The index name has three rows and is garbled: XP @ #@ R

-- The following is an example of MySQL statement for concatenating strings: -- Assign values to the variables to be spliced SET @ VARNAME = 'lil '; -- Concatenate a string, where? Is the parameter for executing the concatenated string statement,

Background: The PostgreSQL server runs on RedHat Linux and the IP address is 192.168.230.128. The client is installed on Windows XP with the IP address 192.168.230.1 Configuration method: 1. Modify the/opt/postgresql/data/postgresql. conf file on

Procedure: 1. Create a temporary tablespace for transit 2. Delete the original temporary tablespace 3. re-create it. Operation Command: Create a temporary tablespace Create temporary tablespace temp2 Tempfile '/u01/oradata/orcl/temp02.dbf'

I. IntroductionIn MySQL 5.1, the new replication technology is introduced, namely row-based replication.In short, this new technology focuses on the changes in the table, rather than the previous binlog mode.From MySQL 5.1.12, you can use the

Select * From (Select RowNum field_ByName, d. * From (SELECT B. *, c. loginaccount from jitums. TB_READERS B, JITUMS. tb_rd_account c where B. reader_id = c. reader_id) d Where RowNum = 1; Select * From (Select RowNum field_ByName, B. * From

QL> set line 130 SQL> select name, created, log_mode, open_mode from v $ database;   Name created LOG_MODE OPEN_MODE ---------------------------------------------------------------------------------------------- MDSP 30-OCT-10 ARCHIVELOG READ WRITE  

Lab environment: Server A: 172.21.1.30 Server B: 172.21.1.40 The two servers run two Oracle databases respectively. This experiment uses the scott user as an example for testing. Purpose: Use the copy function of DB_LINK to remotely back up

Patch Pack: p6810189_10204_Linux-x86.isoAfter mounting and unzipping, run./runInstaller-debugThe following error is reported:-------------------------------------------------------Initializing Java Virtual Machine from/tmp/OraInstall2011-08-25_06-52-

DB_UNIQUE_NAMEDB_NAME In general databases, we can see that there is no special difference, but in Multi-instance and multi-data systems, these two are often mentioned. I accidentally think of the two as one stuff. Actually not. My personal

Command summary for Oracle Installation in Linux Su root Mkdir-p/up1/oracle Groupadd oinstall Groupadd dba Useradd-g oinstall-G dba-d/u01/oracle Passwd oracle Chown-R oracle: oinstall/u01 Su-oracle Vi. bash. profile ORACLE_BASE =/

Copy patch filesThe patch number for Oracle11.1.0.7.3 is 9352179, and 9776431 is a problem patch Based on 11.1.0.7.3. Copy the patch file to/opt/orabak. The directory structure is as

CuteUpdate cannot be executed. View lock: SELECT sn. username, m. SID, sn. SERIAL #, m. TYPE,DECODE (m. lmode,0, 'none ',1, 'null ',2, 'row Share ',3, 'row Excl .',4, 'share ',5,'s/Row Excl .',6, 'clusive ',Lmode, LTRIM (TO_CHAR (lmode, '123 ')))

1. Concept of an instance An instance is an Oracle software in the running state, mainly composed of a memory structure and some processes. In Oracle, each database has at least one corresponding instance. A single instance can only open and use one