Thursday, February 21, 2013
Materialized View technology has been available since Oracle version 7. Originally it was called snapshot technology and soon became known as Materialized View Replication. There are several reasons you might want to use Materialized Views in your environment. First, it’s a great way to offload data to a data warehouse or a separate reporting database. Also you can use them to improve query performance by periodically computing and storing the results of aggregated data and complex queries.
The following is based on my white paper for a session I am presenting at Collaborate in Denver, Co the week of April 7th.
This blog is broken into several specific topics on Materialized Views.
What is a Materialized View?
Creating a Complete Refreshable Materialized View
Creating a Fast Refreshable Materialized View
Creating a Fast-Refreshable Materialized View based on a Complex Query
Oracle runInstaller fails on Linux, Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.
How to get Oracle's runInstaller to run on Linux or Unix environment using from Windows using Cygwin as an xterm emulator. Download an...
Whether you are using audit_trail = OS or DB there will be audit files accumulating in the audit_file_dest. Much more if audit_trail paramet...
More on Mater ialized Views Materialized Views What is a Materialized View? Creating a Complete Refreshable Materialized View Creati...
Oracle duplication on 12c. RMAN-04006: error from auxiliary database. RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon deniedOracle 184.108.40.206.0 RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested i...