| |
 |
|
Oracle 8 Tips
by Burleson Consulting |
The Data Warehouse Development Life Cycle
Distributed Oracle Data Warehouses
HOW ORACLE SNAPSHOTS WORK
Listing 9.1 An example of a snapshot that reads a table from an
instance called london.
CONNECT sys/xxxx;
DROP PUBLIC DATABASE LINK london;
CREATE PUBLIC DATABASE LINK london
CONNECT TO db_link IDENTIFIED BY db_pass USING 'london';
--------------------------------------------------------
DROP SNAPSHOT my_replicated_table;
--------------------------------------------------------
CREATE SNAPSHOT my_replicated_table
PCTFREE 10 PCTUSED 40
TABLESPACE ts2
STORAGE (initial 60k next 10k pctincrease 1)
REFRESH FAST
START WITH SYSDATE
NEXT (sysdate+1) + 3/24
AS SELECT * FROM ORACLE. my_master_table@london;
GRANT ALL ON my_replicated_table TO PUBLIC;
--******************************************************
-- Add the appropriate synonyms for the snapshots...
--******************************************************
CONNECT /;
CREATE PUBLIC SYNONYM snap$_ my_replicated_table
FOR ops$oracle.snap$_ my_replicated_table;
|
