Oracle

Connecting  oracle 11g r2 asm instances when you start connecting to ASM, the 10G approach is not connected to the ASM connection is idle instance [[email protected]  ~]# su - oracle[[email protected] ~]$ export oracle_sid=+asm2[[email  protected] ~]

The common Oracle paging query implementation methods are three, respectively, through RowNum, ROWID, or analysis function implementation, this article will be in my Project User_info table of the sub-table as an example, a brief description of the

This is the description of Oracle's backreference of regular expressionsAs you can see from the definition, a substring is included in the form of () in the matching expression, and can be referenced in the form of \? later. \1 corresponds to the

This is going to be a couple of steps.take oracle10g as an example to illustrate the process of changing the SID name. If the database SID is called TestDB, now change to ORCL, there are the following 6 steps:1. Stop All Oracle Services1.1, Oracle's

To establish the tablespace and the user's steps:UserCreate: Create user username identified by "password";Authorization: Grant create session to user name;Grant CREATE table to user name;Grant create tablespace to user name;Grant CREATE view to

Creating an Oracle Index: CREATE INDEX DEFECT_SUBMIT_DATE_IDX on DEFECT (submit_date);Create INDEX Defect_dbid_submit_date_idx on DEFECT (DBID, submit_date); Delete indexes: Drop index DEFECT_SUBMIT_DATE_IDX; Set monitoring index: ALTER index DEFECT_

[Email protected] oradata]$ export oracle_sid=appdb[[email protected] oradata]$ lsnrctl startLsnrctl for linux:version 11.2.0.4.0-production on 22-may-2014 11:42:15Copyright (c) 1991, Oracle. All rights reserved.Tns-01106:listener using Listener

Oracle Cold backup is a consistent backup, the contents of the backup are data files, redo files, temp files, control files, etc.Sqlblanklines on is the prevention script has a space, sqlplus mistakenly think is the end, reportedSp2-0734:unknown

Unconditional insert Insert all in Oracle refers to inserting the same batch of data into different tables. If there is a need to insert the data in table t into t1 and t2 separately, if you do not know insert all, you may insert data twice using

[Root @ localhost ~] # Su-oracle[Oracle @ localhost ~] $ Sqlplus '/as sysdba'SQL * Plus: Release 11.2.0.1.0 Production on Tue Apr 22 17:10:52 2014Copyright (c) 1982,200 9, Oracle. All rights reserved.ERROR:ORA-12162: TNS: net service name is

Balance between performance and security For database optimization, there is no absolute performance and no absolute security. Just as the fish and the bear's paw cannot have both sides, they cannot have both sides, just like the spear and shield.

Startup succeeded. After a long time, DBA Xiao Li closed his computer and used boiling water to soak himself in a bowl of old altar pickled cabbage noodles. Chinese DBAs prefer to pull curtains and enjoy the unique food in the dark. Senior DBAs

1. Let SELECT TO_CHAR (sal, 'l99, 999.99 ') FROM emp where rownum SELECT TO_CHAR (sal, 'l99, 999.99 ') FROM emp where rownum SELECT TO_CHAR (sal, '$99,999.99') FROM emp where rownum /* -- Description: For the '$99,999.99' format OPERATOR:L:

1. Create tables and partitions create table test(IDVARCHAR2(32),MONTHSVARCHAR2(40),USERIDVARCHAR2(20))partition by list(MONTHS) ( partition m201404 values('201404'), partition m201405 values('201405')) 2. Insert data insert into test values('1'

An error occurred while installing Oracle10G runInstallert on AIX. Environment: System: AIX5300-08 Database: Oracle 10g (64bit) After the oracle software is uninstalled on the AIX client, a daily error occurs: Check whether the system

Analysis of association Design [Paradigm] Ideally, any table in the database will correspond to an object in real life. For example, a player is an object, a team is an object, and a competition is an object, the competition result is an object, and

1. Which departments have more people than department 20.Select deptno, COUNT (*) FROM EMPGROUP BY DEPTNOHaving count (*)>(Select count (*) FROM EMPWhere deptno = 20);2. Who is SMITH's leader (non-associated subquery ).SELECT ENAMEFROM EMPWhere

Today is July 26,. the blog that has been away for N years will continue to be used today. I have been busy leaving my job recently, and I have not paid for my new job, so I am not so stable at the beginning. Learning requires a calm and secure mind.

ADDM checks and analyzes the data obtained by AWR to identify possible problems in the Oracle database and provides optimization suggestions. The method for obtaining ADDM is as follows: @?/rdbms/admin/addmrpt.sqlThe following is an example: -- Step

In ORACLE databases, there are many RMAN backup scripts. The following describes how to use shell scripts to back up data through RMAN, upload RMAN backup files through FTP, and archive log files. Fullback. sh, which uses