Oracle

1. Install the Linux system C3 on a bare metal and prepare it to join the C1,C2 two-node RAC environmentTo have two NICs eth0,eth1Slightly2. Adjust/etc/hosts fileTurn three nodes into the

Oracle 11g under the function of automatic expansion of the partition, it is very convenient, but also brings a problem, that is, after the export, import, the build Table statement changed, the following to do an experiment:Sql> select * from

CREATE TABLE "Brand_relation"("ID" number (10,0) is not NULL ENABLE,"CATID" number (10,0) is not NULL ENABLE,"brand_id" number (10,0) is not NULL ENABLE,PRIMARY KEY ("ID"));CREATE SEQUENCE "Br_id_seq" NOCACHE;CREATE INDEX "Br_catid" On

I don't know how much you know about Oracle? is not just to reach the level of use. If so, follow my steps to get to know Oracle and slowly uncover the mysteries of Oracle.For the installation of Oracle, here I do not want to say, the tutorial

The recent use of Oracle database development, only need to batch update a single field in a number of records, and then need to change the needs of multiple fields to update, so view the information to get the following content, share to everyone.

1. The statement to be rewritten is as followsUpdatetable1 FSetF.ljjine1=(SelectNvlsum(NVL (B.jine1,0)),0) fromTable1 bwhereB.kjqjF.kjqj andB.gs=F.gs andB.bm=F.bm andB.yw=F.yw andB.currency=F.currency andSUBSTR (B.KJQJ,1,4)=SUBSTR (F.KJQJ,1,4)),

1. IntroductionOracle database system is one of the most popular client/server (client/server) or B/s architectures in the United States Oracle Corporation (Oracle) provides a distributed database-centric set of software products. For example,

A new error message was found recently when monitoring the system log, which is strange, not before. As follows:ORA-24777: The use of non-portable database links is not allowed.The tracker went in. It was discovered that a remote library table was

1 IndexThe goal is to improve the speed of the query, when the user is not satisfied with the query speed and needs to adjust the performance of the database, the priority is to establish an index.The concept of indexes in a database is very similar

Recent data processing, often encountered in the need to row to column, a career change scene, recording a very simple and practical Oracle column change, row to column method1, row to column, the basic data is as followsDoing row-to-column

1, the default way to createThe referenced data cannot be deleted when it is deleted.SQL code CREATE TABLE T_invoice (ID number () is not NULL, Invoice_no VARCHAR2 (+) not NULL, CONSTRAINT pk_invoice_id PRIMARY KEY (ID)); CREATE

Oracle Common Sql 1. View the archive mode of the database and whether the flashback is enabledSelectlog_mode,open_mode,flashback_on fromv$Database;2. View instance StatusSelectStatus fromv$instance;3. Uninstalling a DB instanceShutdownImmediate;4.

Using Oracle under ASP. "Failed to load file or assembly ' oracle.dataaccess ' or one of its dependencies" error occurred. This indicates that the driver for Oracle is not installed, or the wrong version is incorrect.1, check whether

Compiler Warnings Compiler WarningOracle 10g allows-enable compile-time warnings that is useful to identify potential run-time problems in your prog Rams. These warnings is not serious enough to raise a exception at compile time and may cause

Analysis:We usually in the development process will encounter a lot of program modification or bulk modification of data when the script will choose the form of the file is executed by the command, then how to execute SQL script file with Plsql or

Installed n Oracle, yesterday afternoon installed server Oracle, the results encountered a problem, let me baffled its solution, but finally in the help of everyone finally solved.I installed the server is Windows Server 2007 64-bit, after the

Common oracle database commandsConn is used to connect to a new user. It is often used to switch the user's conn user name/password to connect to the new user show user to view the current user disc to disconnect the current connection, but do not

Create the PSU 11.2.0.3.8 and then create the database. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. SQL> select created from v $ database; CREATED --------------------------------------- ----------------------

Import excel Data to oracle If you want to import excel data to an oracle table, the columns in excel are the same as those in the oracle table. The content and table in excel are as follows: Copy the excel content to Z sheet?

ORACLE11G is imported from instance 1 full database to instance 2 on the same linux Server Export command in the early stage: [root@powerlong4 ~]# su - oracle[oracle@powerlong4 ~]$ export ORACLE_SID=pt1;[oracle@powerlong4 ~]$ expdp \'sys/systestpd