Oracle

The Oracle database uses that primary key generation strategy 1. Automatic Growth identity: For MySQL, DB2, MS SQL Server, a database-generated primary key for generating unique identities for long, short, int types Using the self-added fields of

Handle exceeding the maximum number of open cursors exception (Ora-01000:maximum open cursors exceeded) Ora-01000_maximum_open_cursors_exceeded_ The Ora-01000:maximum open cursors exceeded exception is often encountered when executing the following

The 2-table field VARCHAR2 (4000) Now expands the length, but continues to expand the error, which has reached the maximum length of the VARCHAR2, so the plan will need to change from varchar2 to blob; Current 2-table field types ALTER TABLE

Foreign key indexing is common sense and must be kept in mind. I did not want to write this simple case, but encountered several consecutive foreign keys without indexing caused performance problems, so write it. A brother asked me to delete from

1. Download from www.oracle.comInstant Client package-Basic: All files required to run OCI, occi, and JDBC-OCI applications,instantclient-basic-nt-11.2.0.3.0.zip(51,149,941 bytes) 2. Install the downloaded client package to D: \ oracleclient, for

  The concatenation operator is the double vertical line "|". The concatenation operator connects the strings of the two fields. Such as name and age 1. Select uname | age as "name and age" from uinfo;Select uname | age as "name and age" from

   1. Rebuild index and parallelism description In the previous blog, I sorted out some index-related blogs:   Oracle index details Http://blog.csdn.net/tianlesoftware/article/details/5347098   How to speed up index

Here are several ways to manually issue the "create database" syntax for Oracle: Extremely minimal manual database creation OMF minimal manual create database syntax Standard Oracle create database syntax Extremely minimal manual database

Hardware requirements[# Root @ sun10g/] #/usr/sbin/prtconf | grep "memory size" Memory size: 1024 megabytes[# Root @ sun10g/] #[# Root @ sun10g/] #/usr/sbin/swap-S Total: 159060 K Bytes allocated + 26872 K reserved = 185932 K used, 2167140 K

The Oracle database software provides the following two scripts to configure automatic database startup and shutdown with the server:[Oracle @ prod bin] $ pwd/U01/APP/Oracle/product/11.2.0/db_1/bin[Oracle @ prod bin] $ LS-l DBS *-Rwxr-x --- 1 Oracle

  I. First read the instructions on the official website. 1.1 V $ nls_parameters V $ nls_parameters contains current values of NLS parameters.           Column Datatype Description  Parameter   Varchar2 (64) 

Select aru_release_name | '.' | minor_version | '.' | tape_version version, Row_source_comments memo, Base_release_flag From ad_releases ---------------------------------------------------11i. 5.10.2 created by snapshot-preseeding SQL script n11i. 5.

The procedure is as follows: // // 1. After installationOracle 11g R2 for x64 LinuxCopy the occi header file and library file:// (1). Copy the header file// Mkdir-P ~ /OCCI-11gR2-X64/include// CP $ ORACLE_HOME/rdbms/public /*~ /Occi/include///// (2).

After two tests, RAC is very fragile.1. Remove the public network cable of Rac1 and stand next to rac2 to see the changes. It is found that the VIP is quickly converted to rac2 and users can still use it.2.1 minutes later, rac2 restarts

Solution to EM (dbconsole) Startup failure after Oracle 10g host name or IP address is changed: From: http://sjsky.iteye.com/blog/644197PS: the host name or IP address is changed. If only PL/SQL is used to connect to the database, you do not need

Import c: \ oraclexe \ app \ oracle \ product \ 10.2.0 \ Server \ JDBC \ Lib \ ojdbc14.jar to the project attribute library in eclipse PackageJDBC;   ImportJava. SQL. connection; ImportJava. SQL. drivermanager; ImportJava. SQL. resultset; ImportJava.

[PHP] Server Information: Linux + apache2 + OracleThe following steps assume that Linux + apache2 + Oracle has been correctly installed, especially the environment variables of oracle.[Make sure that you have correctly set the Oracle environment

Introduction: after the former CEO of Hewlett-Packard Hurd went to Oracle, the two were separated from the sweet league. After the former CEO of SAP entered the position of HP's successor to Hurd, the three parties were formally matched. In

Ora-38301 error, recycle bin A colleague told me a few days ago that there was a serverTablespaceCannot be deleted. Let's see. Log on to the server and delete the tablespace,DatabaseSame timeOra-00604AndOra-38301Error. At first, I thought

In the dedicated connection mode, the server establishes a connection with the client for every client request to connect to the database server. This connection is used to process all requests of the client, until the user actively disconnects or