Difference between revisions of "Create materialized view on prebuilt table"
Jump to navigation
Jump to search
(Created page with "With a slow network bandwidth between the transaction and data warehouse servers, using create mview on prebuilt table can speed up the mview creation * Export data of the neede...") |
|||
(One intermediate revision by the same user not shown) | |||
Line 20: | Line 20: | ||
* http://hemantoracledba.blogspot.com/2009/03/materialized-view-on-prebuilt-table.html | * http://hemantoracledba.blogspot.com/2009/03/materialized-view-on-prebuilt-table.html | ||
− | [[Category: | + | [[Category: Database Features]] |
Latest revision as of 12:57, 20 March 2012
With a slow network bandwidth between the transaction and data warehouse servers, using create mview on prebuilt table can speed up the mview creation
- Export data of the needed table.
- Transfer the export file to the destination
- Import data to create table.
- Create materialized view on prebuilt table
create materialized view DEST.TABLE on prebuilt table using index tablespace INDX refresh force as select * from SRC.TABLE@DBLINK;
- Perform fast refresh.
exec dbms_mview.refresh('TABLE','F');
References: