“Performing a refresh operation requires temporary space to rebuild the indexes and can require additional space for performing the refresh operation itself.” “Not all materialized views may be fast refreshable. Therefore, use the package DBMS_MVIEW.EXPLAIN_MVIEW to determine what refresh methods are available for a materialized view.” Refresh methods: Incremental : Two types: logg-based refresh and partition change tracking (PCT). “The incremental refresh is commonly called FAST refresh as it usually performs faster than the complete refresh.” Complete refresh DBMS_MVIEW package DBMS_MVIEW.REFRESH DBMS_MVIEW.REFRESH_ALL_MVIEWS DBMS_MVIEW.REFRESH_DEPENDENT Traditional methods: FAST (‘F’), COMPLETE (‘C’), PCT…
Day: March 24, 2019
Using DATAPUMP utility to import tables with In-Memory Column Store in Oracle 12c
In this post I am going to show you how to perform an import using Datapump utility from one database to another with the purpose being to use IM Column Store through the export and import of one table called TECHDATABASKETBLOG under the schema SH. Therefore, the first step is to have your database configured to use IM Column Store (if not, check out : https://www.techdatabasket.com/enabling-oracle-database-in-memory-database-in-memory-option-in-oracle-database-12c-release-1/) and the second step is to have some table configured to use it (if not, check out: https://www.techdatabasket.com/enabling-and-disabling-table-for-the-im-column-store-in-oracle-12c/) . After this you are ready…