Oracle

Installation of oracle9i in unix: 1. Work as a root user 1. Configure Kernel Parameters Log on as a root user # Sam enters system administrator manager Select the kernel configuration. after entering the information, select retriable

OracleOfBLOB FieldType can be used to save binary data with a long length. However, the Code for reading and writing BLOB field data is usually very wordy, and it is easy to make mistakes without careful coding. I integrate this feature into my OCI

InOracle Network StructureInConnectionThe problem is a headache for many people. It is the connection problem in the Oracle network structure that has brought a lot of inconvenience to everyone's work, next, we will teach you how to solve the

Oracle DatabaseDevelopers or DBAs often encounter the following problems in their actual work:TableWhen you create a unique index for one or more columns in, the system prompts ORA-01452: you cannot create a unique index and duplicate records are

Oracle DatabaseIt is a database management system that everyone is very familiar with. It is also a database that many enterprises are using. This article will explain OraclePhysical StructureTo help you understand the most basic knowledge of Oracle.

How to configure the oracle database in win7: Environment: Windows 7 (64bit), oracle 11g (64bit ). In the course of the experiment, oracle is damaged. You need to uninstall it before installing oracle again. Steps for uninstalling oracle 11g: 1.

Three standard backup methods for Oracle databases: 1. Export/Import EXP/IMP ). 2. Hot Backup. 3. Cold backup. Note: Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup. 1. Export/Import) The Export can be

I. Introduction ORACLE partitioning is a technology that processes ultra-large tables and indexes. Partitioning is a "divide and conquer" technology. By dividing large tables and indexes into small pieces that can be managed, you can avoid managing

We are working on compatibilityOralce,Db2During development, you need to pay attention to some issues to avoid incompatibility and problems for developers. In this example, the premise is that the db2 version is 9.7 and the database is created after

When weRemote ServerOnOracle DatabaseDuring the operation, you should first establish a connection before calling RPC and other operations on the database on the remote server. The last thing to do is to disconnect and delete the link. This is a

Oracle DatabaseWhat types of files are there? Under what circumstances can these files be easily damaged? How can I fix the damage? This article introduces these contents, including the process of Oracle File Corruption and restoration in 10. These 1

InOracle DatabaseWhen we execute a query, we usually need to sort the query results. SortORDERClause. This article summarizes the sorting of Oracle Database queries. Next we will introduce these. Sort by pinyin (default) Select * from perexl order

HowOracle DatabaseProceedCold backupWhat about it? If yesCold Backup Remote recoveryWhat settings are needed? This article mainly introduces this aspect. Next we will start to introduce it. I. Cold backup Take oracle10g as an example. Coldbak script:

InOracle DatabaseIn the Oracle databaseTNSListenerUnable to start, because my small black memory is only 512 MB, so half of oracle services are set to manual start. Today, we suddenly found that the TNSListener service could not be started,

Oracle DatabaseView and modify the serverCharacter SetThe method is described in this article. Let's take a look at this part. A. oracle server Character Set Query Select userenv ('language') from dual The NLS_CHARACTERSET is the server-side

Oracle DatabasePackageConstruction ProcessThere is no name. It is the part that begins with begin and ends with end after other processes of the package are implemented. This article introduces an example of the construction process. Let's take a

Oracle 10gListenersListener cannot be startedThere are many reasons for this. In this article, we will summarize the reasons that cause the listener to be disabled. Let's take a look at this part. 1. When the following prompt appears in Oracle: ora-0

Oracle 11g R2DatabaseExample userThe installation instructions are what we will introduce in this article. We know that in Oracle10g, if we do not select an installation example when creating an instance, after creating an instance, you can also use

OracleDatabaseREAN recoveryOfData File recoveryThis is what we will introduce in this article. We know that apart from the system tablespace data file mount, other data files can be restored in the open (mount) state. Restoring data files in the

OracleDatabaseUndo log playbackProcess-related knowledge is what we will introduce in this article. Next we will take a look at the description: a seemingly correct process requires a restart after the system goes down, during the restart process,