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

Oracle EBS Submission Request encounters a "rogue" error today when submitting a request, encountering a request run error, status prompt "No manager". The solution is as follows: 1. Switch to system administrator responsibilities. Find the standard

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. Principles of Index use?Do not use full blur on the index, but like ' asdf% ' is possible, that is, do not contains, available StartwithDo not perform functions on the index, expression operations, or use is null to determine, otherwise the full

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

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),

Today, a database synchronization problem is encountered, the main library is closed, after restarting the main library, the repository does not synchronize the main library data properly. The repository can be consistent with the main library only

/* 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

Installation of Oracle1. Download Oracle 11g2. Extract the two compressed packages to the same directory (content merge), i.e. "Database" and click on the "setup.exe" file under the extracted directory as shown in:3. The following command prompt

A few days ago, on the test server, install an ERP system simulation environment.In the process of installing Oracle, I encountered the Oracle's EM unreachable, today tossing a morning, finally solved.Symptoms: Just loaded Oracle 11G, is accessible,

Two methods:1. When creating a table, copy the data from the other tables ( and the structure of the table is also copied over ):Grammar:　CREATE TABLE table_name as SELECT column1,...... |* from Table_old;Sql>SQL> Create Tableuserinfo_new2 as 3

--Locate the specified snapSelectSNAP_ID,Max(sample_time) fromsys.wrh$_active_session_historyGroup bysnap_idOrder bysnap_iddesc;--AWRSELECT * from TABLE(dbms_workload_repository.awr_report_html (Selectdbid fromv$Database),1, 26663,--begin

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

Restoration Methods for deleting online redo logs of Oracle databasesThe online redo log of the Oracle database contains Operation Records of all data in the database. We can use the redo log to perform many operations, such as log mining. Sometimes,