Oracle

Have time today to tidy up the Oracle database notes. In the development process, more or less involved in some of the database aspects of things, it is necessary to sort out the need to drop./* First step: Create a DB instance */You can build on

Create a temporary table space create   temporary   Tablespace test_temp tempfile  " c:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf " size 32m autoextend  on next  32m maxsize 2048m extent management local; Create a

One upgrades today the 10g cluster environment to 10.2.0.5. Download the patch P8202632_10205_linux-x86-64.zip, unzip the installation and run after. Midway Is. Error:I/O ERROR cannt reading or opening file in/tmp/...../temp52Online search for

Yesterday at noon, query to the server data running the latest record is 8 in the morning, the field View service log is very strange, the log output shows hanging dead in the database connection this step. Many times debugging no results, and then

Oracle can use (+) to replace the left and right connections, the interesting thing is the plus sign on the left is the right connection, the plus sign is to make a link to the bottom, as followsSelect A.*, b.* from a.x (+) = b.x is a right

First of all, thanks to these two users: http://zhidao.baidu.com/link?url=eGYeoEa-EhQdVitSGqjE36uNfVmEsryXH1WUjPue6YvArDSx-Y1N9_ Rd9hx6vh-nklyevkcctamh1x28fi1hoqIntroduction:I created a connection called "OA" in the Oracle SQL Developer tool, then

1. Grammatical structure:Select... start with...connect by...priorFor example: there is a unit (unit) Table with three field IDs, Name,parentid (unit ID, Unit name, ancestor's unit ID)1.1 Query all units below the unitSelect from unit t start with

2015-09-24Vim/etc/rc.d/init.d/oracle#!/bin/bash# Oracle:start/Stop Oracle Database 11g r2# chkconfig:345 - Ten# description:the Oracle Database is an Object-relational Database Management system.#./etc/rc.d/init.d/Functionslockfile=/var/lock/subsys/

Recently developed the process of processing ECIF related projects, using Stored procedures to run batch processing data. Run batches of data regularly, each time the stored procedure runs using temporary tables for data collation, and then join

Execute the following commands by using SYSTEM account login Oracle:　　>sqlplus System/[email Protected]:1522/xe;Sql*plus:release 12.1.0.1.0 Production on Tue Sep 22 20:16:29 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle

After the local Oracle connection is created, the default is the GBK character set, if the connection server is not the same GBK character set will appear in Chinese garbled problem, this situation we need to modify the local character set to match

--first log in with the administrator's account (to have permissions to modify the user) system, the default database ORCL.Create user LCS identified by LCS default Tablespace lics_cs_data;--creating users and passwords, specifying table

1. Log in to SQL Plus:What are the system users:1. Sys,system users with higher privileges;2. Sysman Operations Enterprise Manager uses.The 1.2 password is set by the installation of Oracle.3. Scott user; The user's password is the default tiger.(1),

The operation of the Oracle database is mostly done on the client, so in many client software I chose Pl_sql, talk about the basic installation and operation of Pl_sql, as well as some problems encountered in the operation;1. First download the

1 , Import Database (DMP )In Linux systems:1. Log in to the server with the root account and switch to the Oracle account (the account used to install the Oracle database)2. Switch to Oralce under the bin under the installation directory3,

/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace user_tempTempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;/* Step 2nd:

1, Oracle installation, to choose the character set for Chinese encoding, database important role set password, do not start with a number, or the following will be reported some error message2, EMP Export data DMP format, import in the server to

1. Deleting data: Delete statement:Grammar:DELETE from table_name;(1), unconditional deletion:SQL>createtable testdel 2as Select * from userinfo; The table was created. SQL> Delete from Testdel; 4 rows deleted. SQL>Select* from testdel; rows

Someone in the group asked: how does table A (id,name) Table B (item_id,name,a_id) in Oracle now conform to a. Name=b. The ID of the a table of name is updated to a_id in table BI say this: Update B set a_id=a.id from a inner join B on

Explain the usage of distinct in oracle, oracledistinct Let's take a look at the example below: Table Field 1 Field 2 id name 1 a 2 B 3 c 4 c 5 B The library structure is like this. This is just a simple example, and the actual situation is much