two-way streams replication environment, update the conflict resolution (SET_UPDATE_CONFLICT_HANDLER) There are 4 method were MAXIMUM, by resolution_column the value of the column list in the column to determine the value of the value of the check wh ...
A recent offer the following data in EXCEL format Name of school students to the number of listed companies 0 AA a small company Bama AA company NULL 0 AA company NULL 0 AA company NULL 0 AA company NULL 0 AA company NULL 500 BB company Bama two smal ...
[1] the index of the basic concept of query DBA_INDEXES view available a list of all indexes in the table, pay attention only through USER_INDEXES way to retrieve the model (schema) index. Access USER_IND_COLUMNS view given in the table gives a speci ...
ORA-01207: file updated than the control file - old control file under the oracle document explained: Cause: The control file change sequence number in the datafile is greater than the number in the control file. This implies that the wrong control f ...
73. How do I back up one or more separate tables? exp user / password tables = (table 1, ..., table 2) 74. How do I back up a single or multiple users? exp system / manager owner = (User 1, user 2, ..., user n) file = Export File 75. How to CLOB fiel ...
101. How to search out the pre-N records? SELECT * FROM empLOYEE WHERE ROWNUM <n ORDER BY empno; 102. How do you know how many machines, Oracle supports a number of concurrent users? SQL> conn internal; SQL> show parameter processes; 103. Db ...
http://hi.baidu.com/jstm_mm/blog/category/% CA% FD% BE% DD% BF% E2% D6% AA% CA% B6 http://blog.sina.com.cn/s/articlelist_1290195934_0_1.html
1.windows command line to start sqlplus: sqlplus-> user & pwd (to connect to orcal: user: system pwd: 000000) 2. See the current date: select sysdate from dual; 3. To create a user: - method 1: create user "username" identified by &q ...
First of all, there is a info.txt file, the contents of the documents is one of the following circumstances First, the next in oracle to create the corresponding tables, is structured as follows: The next configuration of the control file into info.c ...
As a DBA should always deal with the data, this time the user submits a batch of text files, basically there is a pattern, a total of more than 100 documents, if in turn change the sqlldr control file, the workload can be imagined The use of bat prog ...
The reasons for deadlock 1. Simulation of Deadlock 1.1. Main table - Create table create table WDZ1 ( WDZ1ID NUMBER not null, MEMO VARCHAR2 (20) ) ; alter table WDZ1 add constraint XXXXXX primary key (WDZ1ID); 1.2. From the table (no foreign key inde ...
Oracle's Transportable Tablespaces Overview
