Oracle

Second, create a replication environment The creation is very simple, you only need to perform the following procedure on the target side (if there is more than one table space to replicate, just add t_names (2), T_names (3) ... t_names (n)):

The Range partition table and the interval partition table can be converted to each other, but there is a difference. For example, in the split partition, the range partition table is not restricted, and the interval partition table may be an error.

The interval partition is actually a special range partition, so it's convenient to convert a range partition table into a interval partition table, and you can also convert a interval partition table to a range partition table. For a normal range

Oracle 10g RAC move under virtual machine recently, the VIP of Oracle cluster Resource could not start normally, received crs-0233:resource or relatives are currently involved With another operation error prompt. Why, originally AH, moved the

The partition key value of the list partition table is a discrete value, so it has DDL maintenance statements that are unique to other partitions, ADD values, and Dorp values. Add values and drop values increase or decrease the corresponding

Flashback Version Query, introduced by Oracle 10g, can see how records have changed over a period of time, relative to flashback query can see only a certain point of object state. Based on this history, DBAs can quickly determine at what point in

Flash Recovery area space is not enough to cause the database to open or hang to live 1. Problem and resolution process Sql> select status from V$instance; STATUS ------------ Mounted sql> ALTER DATABASE open; ALTER DATABASE Open * Line 1th

This process is called the parsing process in order to translate the SQL text written by the user into an Oracle-aware and executable statement. Parsing is divided into hard parsing and soft parsing. A SQL statement must be hard resolved the first

We already know that log buffers are used to store log information about the changes in transactions to the data block. So what is the content of the log information here, and what is the structure of it? The smallest unit of Oracle record database

ROWID is a rownum-like pseudo column that locates a relative unique address value for a record in a database. Typically, the value is inserted into the database table when the row data is is determined and unique. For clustered tables, because of

The role switching between Data guard master and subordinate libraries is divided into the following two kinds: 1) Switchover Swithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, there

Before you can create a logical repository, you must first create a physical repository, and for how to create a physical library, refer to the Data Guard series (4)-Creating a physical repository without stopping the main library. 1. Stop the Log

1. The concept of the channel A channel represents a stream of data to a device (disk or tape) and produces a corresponding server session on the target database or a secondary database instance (server sessions) Multiple channels generate

Case 7: --Recovery with incremental backups 1) Establish an incremental backup -------0-level backup using image backup as an incremental backup rman> copy datafile 2 to '/disk1/rman/prod/users_%s.bak '; 2) Establish a level 2 differential

Initialization parameter remote_os_authent is used to control whether remote operating system authentication is allowed. By default, the database runs only the operating system validation on the local server: Sql> SELECT * from Global_name;

A well-designed, performance-capable database engine can easily serve thousands of users at the same time. And the "weak" database system with more users to access the system will greatly reduce its performance. In the worst case, it could even

I. Basic ENVIRONMENTAL requirements System environment: System version: Rhel5u8 x86_64 Oracle Version: Oracle 10.2.1 IP Address ODB1 192.168.100.144 192.168.101.144 ODB2 192.168.100.143 192.168.101.143 Server Shutdown selinux/iptables

The recovery of a missing database file depends to a large extent on the backup strategy used. Based on the flexibility of recovery, this paper discusses the backup and recovery strategy of Oracle8 database, and gives the project development example

One, about ADO In a database environment based on client/server architecture, data can be accessed through OLE DB interfaces, but it defines low-level COM interfaces that are not only difficult to use, but are not accessible by advanced programming

One, what is registration? Registration is the registration of the database as a service to the listener. The client does not need to know the database name and instance name, just know that the database can be used to connect to the database with