![]() A materialized view log is created on the source table to record all the changes made to the source table.Can be refreshed incrementally using a PL/SQL package supplied by Oracle.Often used to replicate data across a database link from another database. ![]() A simple, single-table materialized view.Materialized views can generally be put into two categories They are available in standard edition Oracle, and there is no licensing implication in their use. Today materialized views are one among many replication technologies. Hence the feature was renamed materialized views in Oracle 8i. We are well used to a view being the results of a query, but here the results are materialised into a physical table. They were a way of building and maintaining a physical table to hold the results of a SQL query. This is part of a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |