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

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

This article mainly explains how to proceedOracle 9iOfUninstallI believe that after learning this article, you will be able to master the oracle 9i uninstall method, and hope to help you. In the Windows enterprise operating system, uninstall Oracle

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.

Oracle Character SetIt is a collection of symbols for the interpretation of byte data, which can be divided into different sizes and have an inclusive relationship with each other. ORACLE supports the national language architecture, allowing you to

Oracle DatabaseIt is widely used in various fields of society, especially in the Client/Server mode. However, application developers often encounter the problem that the performance of the entire system decreases significantly as the data volume

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

This article introduces the C # connectionOracleDatabase process. Through the Oracle. DataAccess. dll in instant client and ODP.net, We can conveniently deploy. net applications or sites without installing the Oracle client. Next we will introduce

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

We can useJob MechanismTo export the information in the database to the specifiedTxt text. 1. Open BI and create a new Integration Services Project. 2. Create a table in the database in connection management. 3. Create the txt text you want to

This article focuses onOracle DatabaseThe new features of the 8i, 9i, 10g, and 11g versions are compared and introduced. Now we will start to compare them one by one. What new personality does Oracle 9i have when compared with 8i? 9i is easier to

InOracleUnder the existing system structure of the database,RedologIt is under great pressure. This is because all transactions committed to the database must be written to redolog through the LGWR process before commite confirmation, while an

This article mainly introducesOracle ERPSome disciplinary experience after winning the launch. After years of strong experience in multiple products, I feel that Oracle ERP is relatively fast in terms of background discipline, matching discipline,

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

Oracle DatabaseIf a fault occurs, the database frequently appears after analysis.Archive logsA fault that causes database login failure due to insufficient space. I found that archive logs are frequently switched and the operating system space is

Oracle 10g Shrink TableThe usage is what we will introduce in this article. We know that if you perform DML operations on tables frequently, data in database blocks will be distributed sparse and a lot of space will be wasted. At the same time, it

Last time we introduced:Oracle 11gDescription of default Audit options for databases. This article mainly introduces an Oracle 11g Database.Application Example of audit functionTo help you. There is a property in the user's profile attribute: FAILED_

Oracle 10gMediumFunctions of UNDO dataAndUNDO tablespaceThe common operation is what we will introduce in this article. UNDO data is also called ROLLBACK data, which is used to ensure data consistency. when a DML operation is executed, the data

OracleDatabaseDate range searchThe two methods are the main content we will introduce in this article. Next we will introduce them through an actual example, hoping to help you. For example, to search records with dates less than-1-5, use 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,