Create materialized view on prebuilt table - Revision history

Ittichai at 17:57, 20 March 2012

2012-03-20T17:57:52Z

Ittichai at 17:56, 20 March 2012

2012-03-20T17:56:44Z

Ittichai: 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..."

2012-03-20T16:25:23Z

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..."

New page

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
<pre>
create materialized view DEST.TABLE
on prebuilt table
using index tablespace INDX refresh force as
select * from SRC.TABLE@DBLINK;
</pre>
* Perform fast refresh.
<pre>
exec dbms_mview.refresh('TABLE','F');
</pre>

References:
* http://arup.blogspot.com/2009/01/ultra-fast-mv-alteration-using-prebuilt.html
* http://hemantoracledba.blogspot.com/2009/03/materialized-view-on-prebuilt-table.html

[[Category:Oracle Database]]

← Older revision		Revision as of 17:57, 20 March 2012
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 Features]]	+	[[Category: Database Features]]

← Older revision		Revision as of 17:56, 20 March 2012
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]]