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...") |
|||
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:Oracle Database]] | + | [[Category:Oracle Database Features]] |
Revision as of 12:56, 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: