Create a snapshot in Oracle 8.1.7

Hi

I'm trying to create a snapshot from a db link (remote link in Germany) to my db in local (Italy).
The refresh is very slow but I think that in oracle 8.1.7 is possible create a snapshot without redo log.
How is it possible ?
Which is the command ?
Could you help me?

I use there commands:
On the remote DB :
CREATE SNAPSHOT LOG ON XXX.TEST STORAGE (INITIAL 10K NEXT 10K PCTINCREASE 50); On my DB:
CREATE SNAPSHOT TEST REFRESH FAST AS SELECT * FROM XXX.TEST_at_DB_REMOTE; Sorry for my english....

thank you
Marco Curradi

-- 
Posted from  [40.0.96.66] 
via Mailgate.ORG Server - http://www.Mailgate.ORG