SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Facing Problem in Creating Materialized View of a Large Table

513219Jan 27 2007 — edited Jan 31 2007

Hi

I have a table with around 2 million rows. This table is used in OLTP environment and many records are updated and added to it on a daily basis.

I want to create a Materialized View on this table in another database on a different server. These two servers are connected over the Internet and are not located on the same LAN.

Now when I use a simple "create materialized view" command then the query runs for hours at a stretch and then aborts due to some or other reason - the last run went on and on for almost 16 hours before it aborted.

Please suggest if there is any other way to create the Materialized view that will speed up the process.

Regards
Madhup

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2007

Added on Jan 27 2007

6 comments

675 views