Oracle

In this section, we build a slightly more complex replication environment, and this time we will no longer replicate between two databases, add a new database, and synchronize data between three databases. I. Description of requirements Set the

Specify a partition in addition to using the partition name, many times you can use a for statement. This article describes the ORA-14702 error encountered while testing the for statement. Still use an example from the previous article: sql>

Description: 11g database is now a lot of new deployments, for the 10g database, now clean up the 10g to 11g upgrade process. 10.2.0.2 above version can be upgraded to version 11.2.0.3. Upgrade Note: 10.2.0.5 (->) upgraded to 11.2.0.3 (64) First,

There is no universal, universally applicable value for the size of the shared pool, and different system loads require a shared pool of different sizes to manage. Usually when we set up shared pool, we should follow the "Don't be too big, not too

--************************************* --Oracle Common Performance View list (10g) --************************************* Advisors Information related to cache advisors V$pga_target_advice V$shared_pool_advice V$pga_target_advice_histogram V$

Many organizations have an online transaction processing system. This type of system is characterized by: There are high data update activities that are typically performed by a large number of users. A large number of users concurrently access

Concepts and considerations 1, group function: to a set of data operation, and finally return a value for statistical analysis, all non-null values. 2, keyword DISTINCT can exclude duplicate values. 3, the type of parameter can be

Export mode There are 5 export modes that are mutually exclusive and cannot be used at the same time, noting that some schemas are not exportable, such as SYS, Ordsys, and Mdsys. Full mode Set Full=y (default = N), export whole library, example:

Prior to the dynamic registration of Oracle Listener, static registration is used, the so-called static registration refers to the Oracle instance at startup, read Listener.ora configuration, and then register to listener, which has two main

The password file, or password file, is used to authenticate users who manage through the network. 1. Local connection By default, whether the instance is started or not, the database server local user logon to the database is validated by the

When a sequence is invoked for the first time, it returns a predetermined value, and in each subsequent query call, the sequence produces a value that is obtained by its specified increment. 1. Create sequence The syntax format is as follows:

Profiles are used to limit the system and database resources that are used by users and to manage passwords. If you do not specify a profile when you create a user, The default profile will be used. 1. Create profile by using the "create" Profile

Data integrity refers to the logical consistency and accuracy of the data in the database. Data integrity is generally divided into 3 types: domain integrity, entity integrity, and referential integrity. Integrity constraints ensure data integrity

An Oracle physical structure failure is a variety of database failures that result from corruption of each physical file that constitutes a database. These failures may be caused by a hardware failure or by a human error. So we first need to

1. Foreword In the actual application process of Oracle database, the business processing logic is placed in the stored procedure, and the client calls through ADO. Some business logic processing is large and complex, so that after the client calls

With the advent of the global information Age, information data has become the focus of enterprises, that is, in all kinds of natural disasters or man-made damage, how to ensure the safety of production data and key business of uninterrupted

In Oracle databases, we may experience a lot of data corruption and how it is important to recover data in the face of these situations. In many cases, recovery is extremely complex and requires careful, reckless operations and attempts that can

Oracle Background information Before we introduce Oracle 9i, let's introduce some information about Oracle company to give our friends more insight into Oracle. In 1977, Larry Airison and Bob Miner and Ed Oates created a software development lab

Oracle is a staunch advocate of Linux since the launch of the first commercially available database for Linux platform in 1999. In particular, it has always been a leader in enhancing Linux, availability, and scalability. Recently, Oracle has

Prior to the Oracle 8i release, the internal user was used to perform the database startup and shutdown, as well as create database operations; Oracle has been phasing out internal users since the 8i version, Users who are granted the SYSDBA or