Oracle

Problem: There are two Web servers in the production environment, 227 and 228 respectively, the application code deployed is synchronized daily, the two sides are exactly the same, but some pages query data, 227 no results, and the background report

If you are only accessing Oracle in the development environment, it is recommended to use the Oracle Database Instant Client (Lite), which is relatively small and does not require a green portable installation. Official download Instant Client,

Original: Oracle data typeOracle data typesSaying goes, ax. Knowing a little bit more about the underlying stuff is great for Oracle development and maintenance. Individuals have summed up some of the Oracle data type set solutions, I believe

Mysql/oracle and Hdfs/hbase mutual data via SqoopThe following will focus on the implementation of MySQL and HDFS interoperability data through Sqoop, and the mutual guidance between MySQL and Hbase,oracle and HBase gives the final command.One,

1, the role of swapBoth Systems management and DBAs know that there is a swap partition on both Linux and UNIX systems, which is an example of virtual memory on a Windows system.When the system's physical memory is not enough, it is necessary to

ScenarioThe columns in the original table are defined as VARCHAR2 types, and it is well known that the maximum support length for the VARCHAR2 type is 4000. If you want to convert this column to a CLOB type due to business needs, it is not feasible

This series of articles is a summary of some of the new features of Oracle database 12c, including database management, RMAN, high availability, and performance tuning, Syed Jaffer Hussain.1. Online renaming and repositioning of active data

The main steps are as follows: 1. Download the Oracle thin client and unzip it (without installation) 2. Create an Oracle thin client configuration file (Sqlnet.ora, Tnsnames.ora) 3. Set the environment variable Tns_admin 4. Set Plsql to run as

In this paper, the import and export of Oracle data IMP, exp Two commands are introduced, and its corresponding parameters are described, and then through a number of demonstration examples to drill, deepen understanding.At the end of this paper, we

Recently done a project, through the VC ODBC access to the Oracle database, on my computer can run normally, not on other computers, because there is no Oracle ODBC driver, unable to configure the Oracle data source. Most of the blog posts on the

This error occurs because the host name and the/etc/hosts file are inconsistent, just write the hostname and its IP to the/etc/hosts file, OK.Note that the name cannot be underlinedModify the network file, and then use the hostname command to

1. Process ArchitectureThe processes in the Oracle DB system are divided into two main groups:? Running the application or Oracle tool codeUser Process? Running the Oracle DB server codeOracle DB Process(includingserver processes and background

Hash joins (hash join) is a table join method in which two tables rely primarily on hashing to obtain a concatenated result set when making a table connection.For a sort merge connection, if the result set of the two tables is large and needs to be

1. What is the cursor? Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are returned by the statement, PL/SQL implicitly declares a cursor for each SQL command, such as UPDATE, DELETE, and INSERT. To

Assume that you have a network ordering system based on Microsoft. NET, but the QC maintenance system still uses an old Oracle database application. If your customer places an order such as product replacement during the warranty period, the order

Oracle Installation text tutorial in linux environment in VMware (2) upgrade patch installation in ORACLE 10.2.05, vmware10.2.05 First, decompress the package. $ unzip p8202632_10205_LINUX.zip After decompression, we will find an extra folder,

How to import dmp files in Oracle and import dmp files in Oracle The project started to get the dmp file, and the database used 10 Gb, but it was completely unsuccessful. Later, I decided to give it a try if I wanted to export the file at 11. If

Today encountered an error prompt: ORA-06502: PL/SQL: numberic or value error: character string buffer too small, the general corresponding Chinese information is: ORA-06502: PL/SQL: incorrect number or value: the string buffer is too small. During

/*** Install Oracle-11.2.0.4 * CentOS-6.4-DVD in a CentOS-6.4-minimal-64bit system * 'was originally installed in a Oracle-11.2.0.4.0-Linux-x86_64 system, as a result, the installation was unsuccessful for two days. * The installation was always in

11.2.0.3.7 PSU patch upgrade Description: This is a new host that has not yet been created. If the database already exists, you need to perform the database refreshing operation! Environment: SUSE Linux Enterprise Server 11 sp1 (x86_64) requires