كيف عمل SNAP SHOT

First I think you have to create a database link between the head office and the branches

Using one of the Syntaxes below:

- CREATE PUBLIC DATABASE LINK supply.us.acme.com ;

A public link to the remote supply database. The link uses the userid/password of the connected user. So if scott (identified by tiger) uses the link in a query, the link establishes a connection to the remote database as scott/tiger.

CREATE PUBLIC DATABASE LINK pu_link CONNECT TO CURRENT_USER USING 'supply' ;

A public link called pu_link to the database with service name supply. The link uses the userid/password of the current user to log onto the remote database.

Note: The current user may not be the same as the connected user, and must be a global user on both databases involved in the link (see "Users of Database Links").

CREATE PUBLIC DATABASE LINK sales.us.acme.com CONNECT TO jane IDENTIFIED BY doe ;

A public fixed user link to the remote sales database. The link connects to the remote database with the userid/password of jane/doe.

Then you create the snap shot ( Materialized View)

Create Materialized View View_name

Tablespace Table_space_name

Logging

Nocache

Noparallel

Using Index Pctfree 10

Initrans 2

Maxtrans 255

Storage (

Buffer_pool DEFAULT)

Refresh Force

With ROWID

Using DEFAULT Local Rollback Segment

Disable Query Rewrite As

(Select * From Emp@Database_link_name);

sorry for writing in englsh

hope this enough

السلام عليكم

الاخ mizedin شكراً جزيلاً على الرد

وجزاك الله خير على ذلك

كما أرجو من الاخوه الاعضاء من لديه معلومة اضافيه

أو اي معلومة اخرى عن snap shot تزويدنا بها

ولكم جزيل الشكر

للتأكد من ان الـDB Link تعمل او لأ

select object_name, status from user_objects where object_type = 'DATABASE LINK'

طبعا الكود يحتاج الى القليل من التعديل حتى يعمل من داخل النموذج