Updatable snapshots

From: Andrew Zhilenko <andrew_at_astral.carrier.kiev.ua>
Date: 1997/04/18
Message-ID: <33577d5d@p31.f113.n463.z2.fidonet.org>#1/1

Crossposted in COMP.DATABASES.ORACLE.TOOLS
Crossposted in COMP.DATABASES.ORACLE.SERVER
Crossposted in COMP.DATABASES.ORACLE
Crossposted in RELCOM.COMP.DBMS.ORACLE

Hello All!

Does anybody know, how it is possible to create updatable snapshots, based on complex query (containing qouter join)? May be there is some trick technique... We tried to create updatable snapshot based on simple query, and then drop view for this snapshot, and re-create it as complex. It works with one small table, but do not work with real data.

Best regards,
Andrew

// Intel have announced the amateur Pentium which is really rather good, but // you can only use it on weekends and off-peak hours.

GoldED/386 2.50+
- Origin: GPF is a registered trademark of Microsoft Corp. (2:463/113.31)

Received on Fri Apr 18 1997 - 00:00:00 CDT