Oracle

Oracle RAC add and delete Voting Disks add and delete voting Disk example: Environment: www.2cto.com [plain] [oracle @ node2 ~] $ Uname-a Linux node2 2.6.18-164. el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux [plain] SQL> select *

Oracle RAC backup and recovery Voting Disks Oracle RAC add and delete Voting Disks reference: http://www.bkjia.com/database/201303/195591.html Oracle RAC does not need to back up and recover the Voting Disks www.2cto.com Voting Disks every day.

Oracle Database (ORA-02270: the unique or primary key mismatch for this list) problem was just encountered when writing an oracle database. You cannot find the answer you want on the Internet. I keep thinking about these words. Then, remind me by

Oracle wildcards and operators used for where comparison are: equal to: =, , >=, <> include: in, not in exists, not exists range: between... and, not .... and Matching Test: like, not like Null test: is null, is not null Boolean link: and, or, not

ORACLE Auto-incrementing SEQUENCE in oracle, sequence is the so-called serial number. It will automatically increase each time it is obtained. It is generally used in places where it needs to be sorted by serial number. Www.2cto.com 1. Create

Differences between two oracle query tables oracle query two table differences such as table 1 create table T1 (MAC VARCHAR2 (150), PURCHASENAME VARCHAR2 (200), PRODUCTID VARCHAR2 (200 )) table 2 create table T2 (MACADDR VARCHAR2 (20), PRODUCTID

Background of index creation for some rows: if the data distribution of one column in a table is uneven, most of the data is 1, and a small part is 0, and the data that we often query is exactly 0, in this case, full table scan is a waste of

PL/SQL Chinese garbled correction (import or Update operations)I need to modify some fields of some tables in the database as needed. However, during the Update process, Chinese characters (Type field) are garbled ).At this point, I use a client,

In Oracle, the group by clause can be used in select statements to divide rows into smaller groups, and then the grouping function is used to return the summary information of each group. In addition, you can use the having clause to limit the

A small experiment: Find the critical point when optimizer selects full TABLE scan and index range scan. first CREATE a test TABLE: create table foo (userid number (20) NULL, USERNAME VARCHAR2 (100 ), userdept number (20), USERDEPTNAME VARCHAR2 (100)

Install Oracle 10g2 in CentOS 6.4. centos 6.4 desktop system, without built-in java7 and other unused software, without openoffice and other office and entertainment software. After installation, yum update updates the system to the latest version,

Oracle SQL statement execution sequence The SQL syntax is analyzed from right to left. 1. SQL statement execution steps:1) analyze the syntax and analyze whether the syntax of the statement complies with the specifications, to measure the meaning of

PL/SQL calls JAVA to obtain the MAC address of the NIC. It is mainly used to learn how PL/SQL calls JAVA. platform: WINDOWS 1. first, use PL/SQL to create and compile the JAVA source file (JAVA source) until there is no error. note that when calling

Oracle Views Statement 1: Verify that the view with distinct cannot be deleted. create or replace view dept_vie asselect distinct department_name from orders; SQL> delete dept_vie where department_name = 'finance '; delete dept_vie where

AWR analysis: On a tall building, we can see AWR RoadAutomatic Workload Repository is an important component introduced by 10 Gb.Stores the detailed information and information about the database activity status in the recent period. The default

Oracle foreign key for table data synchronization method 1: When deleting data in a table with a parent-child table relationship, we all know that we need to delete the child table before deleting the data in the parent table, or cancel the foreign

Server-side configuration rac taf (rac application separation) database version: 10.2.0.1 operating system version: CentOS-5.6 1) Create service [SQL] [oracle @ rac1 ~] $ Srvctl add service-d jscn-s taf_dianping-r jscn1-a jscn2-P basic [oracle @ rac1

Oracle spfile is damaged when it is modified online. A few days ago, I was just getting started with ORACLE and knew that the database must be running in archive mode: I had to change it to archive mode: first query SQL> select name, log_mode from v

Manually uninstall the Oracle Database System Environment on Linux: Red Hat Enterprise Linux Server release 5.5 (Tikanga) Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 steps are as follows: 1. stop all Oracle processes $ sqlplus/as

Oracle imp gets stuck. Solution: Use imp to import data. The data volume is not large. Occasionally, it gets stuck in a table. Check the tablespace and alert logs. The number of cursors is insufficient. View the currently used cursor select count (*)