Create materialized view logs
Materialized view logs to create a simple example, cite only the key elements, the rest of the content of interpretation and other objects to create to explain something like this:
rn
- rn
- CREATE MATERIALIZED VIEW LOG ON T3 rn
- WITH ROWID, PRIMARY KEY, SEQUENCE rn
- (ID) rn
- INCLUDING NEW VALUES;
rn
Explained:
rn
- rn
- In T3 the table to create a materialized view log. rn
- WITH clause, whether the record indicated that the primary key materialized views, rowid, object ID, sequence. Through these to identify the main table changes. WITH can tell after the OBJECT ID, PRIMARY KEY, ROWID, SEQUENCE. OBJECT ID only for one object table (object table), PRIMARY KEY require primary table must have a primary key. rn
- column specifies a column that identifies a line change. rn
- INCLUDING NEW VALUES that materialized view log records both the old value is also recorded a new value, if we adopt the fast refresh, you must specify for that. The default is EXCLUDING NEW VALUES, does not record the new value, saving the overhead of record.
Related Posts of Create materialized view logs
-
Logfile damage caused by oracle solution could not be activated
Lessons Learned: Log into the current line-line logs and online logs of non-current, non-current damage to the log-line is relatively simple, clear commands in general can be adopted to solve the problem. Damage to non-current-line log: 1, start the datab
-
How to dump the B * Tree index branching structure
Oracle allows for B * Tree index dump, to show the level of B * Tree structure. Examples are as follows: 1. First of all, the index of choice to study 2. Object_id find the index 3. Dump the index structure 4. Now is the trace file we can see the cli ...
-
Oracle database manually create the causes and effects
For many database administrators, Oracle is not a difficult to manage and control the class of the Monster database, will let them manage the tortured life? When you see the command-line interface, a lot of people would ask such a question. If you wa ...
-
Oracle deadlock related
ORACLE some were killed in the process, the status was set to "killed", but the lock does not release resources for a long time, sometimes it is no way but to restart the database. Now offers a way to solve this problem, that is, in the kil ...
-
SQL optimization (4) - Table of the three connections
Test the following three commonly used connection between the table: Sort - merge connected (sort-merge join, SMJ) Nested loops (nested loop, NL) Hash connection (hash join, HASH) 1. To create the test table SQL> select * from v $ version; BANNER ...
-
SQL optimization (6) - nested loop drive source select line
Under normal circumstances, nested loop drive line source should be chosen small table, or a few lines of the line source, but sometimes, not necessarily. We look at a large table to do the examples of the source line drive. 1. To create a test envir ...
-
SQL optimization (3) - four index
Test the following four types of index: Unique Index Scan (INDEX UNIQUE SCAN) Index range scan (INDEX RANGE SCAN) Scan the whole index (INDEX FULL SCAN) Express-wide scan index (INDEX FAST FULL SCAN) 1. To create the test table and the only composite ...
-
SQL optimization (1) - full table scan and index the test
Test Objective: To test CBO and RBO, as well as full table scan than index the situation quickly. 1. To create a test environment SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- Oracle Datab ...
-
SQL optimization (2) - there is the order of the index data
Data in the index have been scheduled well in advance of the order. So when SQL specified in accordance with the index to sort out when, in the implementation of the plan do not need to sort of. 1. To create a test environment SQL> create table te ...
-
Troubleshooting: the physical set up the backup database
Articles connected to "Fault Diagnosis: A physical backup of database", in the articles on which there is mentioned that in good physical backup of the database set up after the main database found to be unable to synchronize the archive lo ...
Leave a Reply