Oracle

Oracle 10g "dataguard" log Transmission Mode1. Redo transmission: All online redo logs written to the master database are transmitted to the standby database by synchronously or asynchronously. If the standby redo log exists in the standby

In Oracle SQL, union is also a common statement. Note that the Union statement of Oracle filters out duplicate data by default. That is to say, Oracle union has a distinct Statement by default. So how can we not need this attribute? We need to add

Redo file is a very important file in Oracle, if this file is wrong, then oracle will not be able to start normally, the system will report a hateful ORA-00312 error, said the log file has been damaged, so how can we solve it. In fact, it is very

There are two main methods to develop the Oracle database interface in Visual C ++. One method is to use multiple database access technologies provided by Visual C ++, for example, Open Database Connection ODBC, Data Access Object Dao, object

1. If you have a certain database foundation and know what SQL is going on, you can skip to 2 even if you cannot write simple SQL statements but can understand them. Otherwise, let's take a look at the basic database and the SQL language. You don't

The Oracle client of any current version cannot be installed properly on Windows 7 of any version. This is mainly because the operating system version does not meet the requirements for Oracle Installation. However, you can modify refhost. XML to

Before Oracle9i, Chinese characters were sorted by binary encoding.The sorting by pinyin, radical, and stroke function is added to Oracle9i. Set the nls_sort ValueSchinese_radical_m is sorted by the beginning (first order) and strokes (Second Order )

So far, the export/import toolset is still the preferred utility for transferring data across multiple platforms with the minimum labor intensity, although it is often complained that it is too slow. Import only reads each record from the export

This error occurs when you create a database instance while installing Oracle 11g R2, And if you select ignore, A ora-28000 error occurs. After network query and verification, this is a password starting with a number when the administrator password

Single-row functions are mainly divided into five types: The varchar2 function, the number function, and the date function, Common functions, Conversion functions Character FunctionsThe main function is to operate string data, such:. Upper (string

E:/> exp help = y By entering the exp command and user name/password, you canCommand after user/password: Example: EXP Scott/Tiger Alternatively, you can control the running mode of "Export" by entering the exp command with various parameters.

I. Syntax:Translate (string, from_str, to_str)Ii. Purpose Replace each character in from_str with a string after the corresponding character in to_str. Translate Is a superset of the functions provided by replace. If from_str is longer than

Today, the developer asked me how to quickly and conveniently find the recently changed records of a table. This requirement is very simple. Because it is to check recently changed data, you can check the rollback segments, below is my small

Document directory Oracle series: Record and PL/SQL tables Oracle series: Record and PL/SQL tables 1. What are record and PL/SQL tables? Record: a temporary record object type consisting of a single row and multiple columns of scalar type.

 1. Check the Oracle Process $ PS-Ef | grep "ora _" | grep-V grep Oracle 5998 1 0 11:15:59? 0: 01 ora_j000_pprd10 Oracle 2968 1 0 21:16:57? 0: 00 ora_q000_pprd10 Oracle 2927 1 0 21:16:33? 0: 00 ora_pmon_pprd10 Oracle 2933 1 0 21:16:34? 0: 07 ora_dbw0

View the lock table process SQL statement 1:Select sess. Sid,Sess. Serial #,Lo. oracle_username,Lo. OS _user_name,AO. object_name,Lo. locked_modeFrom v $ locked_object Lo,Dba_objects AO,V $ session sessWhere ao. object_id = Lo. object_id and Lo.

    Oracle Data guard synchronizes data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to

  *************** 1. Find the oraparam. ini file under the install directory and find the [Certified Version] node,Add 4.0 after # windows = 5.0, 5.1, 5.2, and 6.1, and then add the following content to the 5.2 node.After

How to Use select top in different databases:   1. Oracle Database (Oracle does not support the select top statement. Therefore, the combination of order by and rownum is often used in Oracle to query the select Top N)   SELECT *

In the storage of Oracle data, you can think of the storage space as a reservoir, and the data as water in the reservoir. There is a line of water in the reservoir called a waterline. in Oracle, this line is called a High-warter mark (HWM ). When a