Oracle

As described earlier, Oracle provides two ways for database-level replication: A, Maintain_global B, Pre_instantiation_setup, Post_instantiation_setup Maintain_global is suitable for small and medium-sized database creation, while

1, the concept of SQL Loader Import external data (such as text) data into Oracle database. (For data import, different types of database data migrations) 2, Sqlloader Import data principle: In paragraph (segment table) Insert record 1) Normal:

When the data in the table is not needed, you should delete the data and release the space occupied, and the data in the table can be deleted using the DELETE statement or the TRUNCATE statement, described separately below. A, DELETE statement(1)

What is a combined multiline string (connection string), for example: sql> desc test; Name Type Nullable Default Comments ------- ------------ -------- ------- -------- COUNTRY VARCHAR2 (Y) City VARCHAR2 Y Sql> select * from test; COUNTRY City ---

The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection)"Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary

Use VBox to simulate storage migration environments, os:rhel5.9,db:oracle 10.2.0.4 RAC ASM 2Nodes. ASM uses extern redundancy, which does not use ASM's rebalance functionality, and OCR and Votedisk are stored in raw. Migration includes Controlfile,

Patching the software is equivalent to giving people a vaccination, which is critical to the stable operation of the system. This paper introduces the classification, installation and management of Oracle database patches in detail and

ORADBI was developed on the basis of Oracle OCI (Oracle Invoke interface), supporting databases such as Oracle8i, 9i, 10g, and so on. According to Oracle's introduction: OCI is so reliable that every SQL statement in an Oracle database is executed

Starting with the Oracle 11GR1 release, Oracle provides a recommended solution for database data file fixes to better enable users to choose a recovery approach This becomes more and more intelligent, and we just need to follow the Fix Advice

Experimental environment: SOURCE End: ip:192.168.40.10 Database:oracle 11.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit Target side: ip:192.168.40.128 database:10.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit First

Oracle_ Single Function _ number function 1.abs (x) To get the absolute value of X 2.ceil (x) Used to get the smallest integer greater than or equal to X 3.floor (x) Used to get the largest integer less than or equal to X 4.mod (X,y) The

In general, Oracle databases operate more efficiently than SQL Server databases in large data environments. From the query optimization alone, the two are quite different. Below, the author of the database query optimization of the difference to do

LOB large Object processing: A database field primarily used to store large amounts of data, which can store up to 4G of unstructured data. Mainly introduces the storage of character type and binary file type LOB data, separately describes the

Today, a friend asked me how to monitor the operation of a pl/sql, here is a brief introduction to several methods. Describes the simplest method of insert. Their problem is to execute the following Pl/sql code: Sql> SET Serverout on Sql> BEGIN

Two days ago, I wrote an article about a series of regular functions such as length to handle LOB types, and someone mentioned in the blog reply that using length is more efficient than dbms_lob. GetLength Low, here's a simple test. Create a test

Oracle connections are common for processes with Local=no parameters or with Local=yes. Local=no: Not a local connection, that is, a network connection. It is connected to the server through listener. The client's application listens to the server

Two days ago, I saw a post on the itpub, referring to how to use the fastest way to SYSDBA log in to the database. The method that is given is to sqlplus the direct carriage return and then enter/as SYSDBA when prompting the user name:

For example, the database administrator now needs to have the Oracle database System Monitor itself. Automatically alert the database administrator when the CPU usage of the server is reached, or automatically remind the database administrator, etc.

A database is a typical representative of a network database. Users can access the database over the network. Oracle database provides a variety of network interconnection schemes, including structure and driver, whose network communication

Index is a common database object, it is set up and used properly, which greatly affects the performance of database applications and databases. Although there is a lot of data on the use of indexing, DBAs and developer often deal with it, but the