Database Administrator

Today, I had to write this article for a long time because of a very strange problem. Select * from wlbtest3 Where (sname, sage) not in (select user_name, user_age from wlbtest4) Select * from wlbtest3 Where (sname | sage) not in (select

MySQL version 5.1.49 # Uname-Linux loDB192168000046 2.6.18-238.19.1.el5 #1 SMP Fri Jul 15 07:31:24 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux # Cat/etc/issueCentOS release 5.6 (Final)Kernel \ r on an \ m # Mysqlhotcopy-u root-p 'Password' database name

1. Classification of constraints. Constraints are divided into five categories: 1. not null, 2. primary key, 3. check, 4. unique, 5. foreign key. 1.1 not null Constraint By default, the values of all columns can contain null values. When the not

Use the Oracle database cluster management tool on the rac1 node to stop the rac1 instance and use the crs cluster tool to stop the CRS cluster service: Stop Note: Stop the instance before stopping the CRS service. Start Note: Start CRS first. to

Version: OS: Enterprise Linux Server release 5.7 Db: Release 10.2.0.1.0 Ogg: Version 11.2.1.0.1 Prepare beforehand (both nodes must be prepared ): 1. Install and start Oracle, upload ogg installation media to/ogg, and decompress 2. Create a ggusr

Environment: SQL> select * from v $ version where rownum = 1; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod SQL>! Uname-r 2.6.18-308. el5xen The

The scenario is as follows: All the original table data is stored in the users tablespace. Now you need to replace the tablespace with the ntbs tablespace. When moving, tables with blob, clob, and long types fail to be replaced. Why? Because blob

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> Allocated channel: t11 Channel t11: sid = 824 instance = ncdb1 devtype = DISK   Allocated channel: t12 Channel t12: sid = 838 instance = ncdb1 devtype = DISK   Allocated

Using Toad to manage local databases is more intuitive and convenient than using sqlplus, and easier to operate. For some large tables, the query results are clear at a glance. In general, the following steps are required: Step 1: Install the local

Oracle dynamic SQL statements are easy to use, but the assembly process is too annoying. Especially when a date field is involved in the Assembly Statement, to_char must be added during the Assembly to convert it into a character first. In SQL,

When writing code, if you need to understand the transfer relationship between Oracle's role, that is, if role A exists, you can grant A to B through grant B to C. then I want to know which role has the permission in all role. I found a recursive

Recently, the company's MySQL architecture has been upgraded, from the original one-master-many slave to the DRBD + Heartbeat dual-master-many slave, and a new e-commerce website project is coming soon, DRBD + Heartbeat dual master and one slave are

Recently deployed project, the following message is displayed in the Linux system for testing (such as test) tnsping orcl using non-Oracle users: TNS Ping Utility for Linux: Version 11.2.0.1.0-Production on 04-DEC-2012 14:29:28 Copyright (c) 1997,200

Objective: To clone the database from the production database PROD to the TEST Database Environment: the PROD/TEST database already exists, and the PROD data file is on the tape; 1. Edit the pfile file of the TEST database; Delete all data files in

During the Oracle storage test, it is found that the values of many columns in the product table may be null, resulting in not exists results inconsistent withThe test is as follows:-- Construct two tables with the same table structureSQL> desc

1. View service1.1 first look at the example of the next Listener: [Oracle @ db2 ~] $ Lsnrctl service   LSNRCTL for Linux: Version 10.2.0.1.0-Production on 19-JUL-2011 01:24:43   Copyright (c) 1991,200 5, Oracle. All rights reserved.   Connecting to

In the last week, I reviewed index-related things. In addition to reviewing concept, I also saw a good document on MOS. Share with you. Document No.: [ID 30405.1] This article is only concerned with B * tree indexes which are currently the most

1. Common Query This is a common and common application scenario of OracleText. Create an index of the Context type in OracleText and generate a large number of keywords to speed up operations similar to common like '% xx %' or query large documents.

Installation environment Linux Server: SUSE10 sp2 64-bit Oracle Server: Oracle11gR2 64-bitSystem Requirements Requirements for installing Oracle in Linux System Requirements Description Memory Physical memory must be

Environment Planning: 1. Hardware: 1.1 node HOST: ESX4.1 creates two hosts with the same configuration. Each computer has two independent NICs. The addresses of each NIC are shown in the table above. 1.2 Storage devices: Log on to the ESC4.1