how to create remote snapshots (through a firewall)

Hi,

i have to set up SQL scripts to create snapshots from tables of an original database on a remote database and to refresh them .... through a firewall, which is sometimes opened from the original to the remote side (at this time the refresh should be done)! the scripts should be started at the original side ...

first problem ... is it possible to make DROP and CREATE SNAPSHOT with database links?
f.i. DROP SNAPSHOT xxx_at_link and CREATE SHAPSHOT xxx_at_link to drop and create them via the link from the original side.

the script is now ..... (started at the remote side)

CREATE DATABASE LINK link
  CONNECT TO xyz IDENTIFIED BY xyz USING 'database';

DROP SNAPSHOT xxx
DROP SNAPSHOT yyy
...

CREATE SNAPSHOT xxx
  STORAGE (
    ...)
  TABLESPACE ...
  ...
  ON DEMAND
  AS SELECT * FROM xxx_at_link

...

the refresh script contains something like that (also started at the remote side)

EXECUTE DBMS_MVIEW.REFRESH('xxx');
EXECUTE DBMS_MVIEW.REFRESH('yyy');
...

both scripts work - without firewall and startet at the remote side.

second question - is it possible to start these refreshs at the remote side from any script at the original side through the firewall which is opened in this direction (original --> remote)?

thanks for any help or hint ...

Falk Berger

Sent via Deja.com
http://www.deja.com/ Received on Sat Feb 03 2001 - 04:55:58 CST