Oracle

ArticleDirectory It is a small problem to install oracle on Windows Server (cpup4 ). It is a small problem to install oracle on Windows Server (cpup4 ). My development environment is. net, so I didn't install Java. Today I saw an

11.2.0.3 the database crashed due to damage to the ASM disk header block and encountered an incorrect ORA-15196.More detailed error: ORA-15196: Invalid ASM block header [KFC. C: 26076] [endian_kfbh] [256] [0! = 1]Further checks have found that the

First, add the Oracle 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears: Figure 1 Click "Start installation" to install Oracle 10 Gb. Generally, check whether the system configuration meets

First, let's talk about MS Server. Because I am a newbie, I first chose to use the Enterprise Manager for task settings and then export the designed task script, in this way, you can directly execute scripts in other databases to create a task (you

  1. debug the process in the Oracle database  OracleThe process debugging format is:  Declare Param_int integrate; Begin Null; -- Operate the data End  SQL server process debugging format: In the SQL server process, you can write SQL statements

Document directory Read Committed Isolation Serializable Isolation Isoation eve) The isolation level defines the degree of isolation between transactions. Isolation level and concurrency are mutually contradictory: the higher the degree of

Although EF6 is coming soon, it is a big pity that Oracle databases can only be programmed with DB first and Model First, rather than Code First. Let's take a look at how EF uses DB first and Model First to program Oracle. First we want to download

The password of scott is incorrect. Go to the Administrator and modify the password of scott. Or change the password as follows: In the running column, press sqlplus (Space)/nolog and press Enter. In the pop-up box, press "conn sys/password as

Before Oracle9i, Chinese characters were sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i.1. Set the NLS_SORT parameter value SCHINESE_RADICAL_M is sorted by Ministry (First Order), strokes (Second

Row_number () over (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the group, the value calculated by this function indicates the sequential numbers after sorting in each group (the sequential and unique

SQL1: Copy codeThe Code is as follows: -- 1. view the table space name and size. SELECT t. tablespace_name, round (SUM (bytes/(1024*1024), 0) ts_size FROM dba_tablespaces t, dba_data_files d WHERE t. tablespace_name = d. tablespace_name Group by t.

The ORACLE tutorial is: FAQs about ORACLE database application development and troubleshooting. Hardware Platform: SUN Ultra Enterprise 3000 Operating System: Solaris 2.5 (Simplified Chinese) Disk: 4.2 GB Memory: 256 MB Oracle B version:

The ORACLE tutorial is: how to solve the Oracle Database loading error areasQueries. Note: ensure that the Oracle installation directory cannot contain Chinese characters during installation. (If the "loading Database Error areasQueries" error

Introduction to iSQL * PLUS ISQL * PLUS is a new feature provided since ORACLE 9i and is a Web form of SQL * PLUS (not supported by ORACLE 11g ). It is designed based on a three-tier structure. Its client, middle, and server can be located on the

Connect to Idle Instance Step 1 View Oracle_SID. [Oracle @ linuxserver ~] $ Echo $ ORACLE_SID Cjdl The SID here must be the same as that in the initialization file spfilecjdl. ora. [Oracle @ linuxserver ~] $ Cd $ ORACLE_HOME [Oracle @

During Oracle database manipulation, an error is prompted when logging on to the Oracle account, and the Oracle account is frequently locked. What are the causes of this fault? This article introduces this process and finds the cause of the fault

Typical problems are: Sometimes, it indicates that an index is created, but the query process obviously does not use the relevant index. As a result, the query process takes a long time and consumes a large amount of resources. What is the problem?

The ora 12154 error is reported when plsql is connected to the oracle database. Today I encountered a problem that sqlplus can be used to connect to a remote database, but plsql cannot be used to connect, error "ORA-12154: TNS: Unable to parse the

Recently, many projects require batch operations. The client passes a set of IDS separated by commas (,) to the database, and the stored procedure needs to separate them and process them one by one. The previous processing methods are as follows: 1.

ROW_NUMBER () OVER (partition by COL1 order by COL2) Indicates grouping by COL1 and sorting by COL2 within the groupThis value indicates the sequential number after sorting in each group (the continuous and unique in the group) RANK () is similar.